InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 19:21:59 GMT20http://www.sqlservercentral.com/Forums/Topic904967-148-1.aspx[quote][b]bob_kudulis (4/16/2010)[/b][hr]I am new to SSIS and I have created a package that loops through files in a directory and imports them into a table. The package works fine but I would like to add the file name that the data came from and add it to a column in the import file or into the table that it was imported into. I have tried adding a derived column but cannot seem to get the value from the variable into it. [/quote]Check this [b][url=http://sqlblog.com/blogs/jamie_thomson/archive/2010/03/31/filenamecolumnname-property-flat-file-source-adapter-ssis-nugget.aspx]post[/url][/b].Wed, 21 Apr 2010 10:24:42 GMTCozyRochttp://www.sqlservercentral.com/Forums/Topic904967-148-1.aspxWonderful, glad to hear it..CEWIIFri, 16 Apr 2010 19:07:03 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic904967-148-1.aspxI was able to finally get it to work. I had to Cast the variable and allow for a longer string. Thank you for your suggestion.Fri, 16 Apr 2010 16:44:32 GMTbob_kudulishttp://www.sqlservercentral.com/Forums/Topic904967-148-1.aspxA derived column is the right path. What are you using to loop through the directory? A For-Each-Loop? Also, why don't you add a data-viewer to see what is in the pipeline immediately following the derived column task.CEWIIFri, 16 Apr 2010 12:09:56 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic904967-148-1.aspxI am new to SSIS and I have created a package that loops through files in a directory and imports them into a table. The package works fine but I would like to add the file name that the data came from and add it to a column in the import file or into the table that it was imported into. I have tried adding a derived column but cannot seem to get the value from the variable into it. Fri, 16 Apr 2010 09:24:41 GMTbob_kudulis