Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wali
Starting Member
7 Posts |
 Posted - 2007-02-07 : 09:50:08
|
| 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 |
|
|
bigRuckus
Starting Member
5 Posts |
Posted - 2007-02-07 : 12:55:16
|
| you can insert a derived column transformation taskbetween the source and destination to do this.Name the column appropriately and uses the variable holding your file name as the expression. |
 |
|
|
wali
Starting Member
7 Posts |
Posted - 2007-02-08 : 08:34:40
|
| Thnx for the reply, just one question tho, how do i get the Variable or Expression that i will include in the 'Derived column transformation editor' to point to the FileName.. |
|
|
|
|
|
|
Insert Filenames in Integration Service???