Insert Filename in table

[atiqraza]

Hello,
I am using Integration services to upload a bunch of files. In my 'Data Flow Task' I have a 'For loop' which picks up every single file in the folder.

Does anybody know if it is possible to insert the Filename as a column so that i can differentiate the rows in my destination table??

Or would it be possible to insert a flag as a column which wold also change when the file changes...this would also help me differentiate the rows in my destination table...

Thanks

 

[AlexCuse]

This sounds like a question for forum1555

I would do this in DTS using global variables to modify the contents of a SQL Task. I'm not sure what you would do for this in SSIS though.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom