This is my first SSIS project and I would like to be pointed into the right direction. I need to loop through an ACCESS table and pick and choose data to be used to fill an SQL Server 2014 table.![alt text] : /storage/temp/3156-question.png
I'm not sure what you mean by "loop", but this sounds like a simple data flow. The access table would be the source, and the SQL Server table would be your destination. Then just map source columns to destination columns.
I'm not totally sure what you are on about, but I think you want to JOIN the ACCESS table and the GLOBAL table together on either KetName = CompanyName or CompanyAdr1 and then INSERT this value into the COMPANY table. INSERT INTO COMPANY ( NAME ) SELECT A.VALUE FROM ACCESS A JOIN GLOBAL B ON A.Keyname = B.CompanyName INSERT INTO COMPANY ( Address1 ) SELECT A.VALUE FROM ACCESS A JOIN GLOBAL B ON A.Keyname = B.CompanyAdr1