One folder contain more than 10 files with naming convention ppp001.xls ,qqq002.xls etc .These files contain data. I need to create ssis package to get file name only and I loaded file name into sql server table already but not needed .Can I load this values into variable directly not in table and want to use this values for matching with sql server table file name column already existing table that contain file name column. How we create ssis packages if you anyone know please let me know.Thanks

I suggest you start investigating the For Each Loop. It the ability to enumerate files. The filename on each loop iteration can be stored in a variable. You could then use an Execute SQL Task inside the loop to query the table.http://www.sqlis.com | http://www.konesans.com

I suggest you start investigating the For Each Loop. It the ability to enumerate files. The filename on each loop iteration can be stored in a variable. You could then use an Execute SQL Task inside the loop to query the table.http://www.sqlis.com | http://www.konesans.com

Hi Ganesh9, Check out the below articles, they will assist you in creating a for each loop: http://consultingblogs.emc.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/61987/ http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx PS: Hope it HelpsRegards, Sifiso W. Ndlovu | Data Analyst| Nedbank Group Ltd Nedbank Head Office, 135 Rivonia Road, Sandown, 2196 South Africa