April 5, 2007 at 11:08 am
I need inputs:
Is there a way that I can get the filename of the file without using VBscript?
What I'm doing, I have a Data Flow Task that a Flat File Source to a DB Destination in a Foreach Loop Container. I have a column name SourceFile, I want this column populated which file it comes from, clear?
e.g. test.txt with 1 million rows populated in a table then populated the column SourceFile with a data of test.txt
P.S. I have liked 50 files to load and I want to keep track of it where the data come from.
April 6, 2007 at 3:55 am
You can use variables in the For Each Loop to keep track of which file you are currently accessing. This will allow you to then access those variables within your loop tasks.
See a good example with screen shots here: http://www.sqlis.com/55.aspx
Hope that helps,
Catherine
Catherine Eibner
cybner.com.au
April 17, 2007 at 11:27 am
Just what I was looking for today! SOOO simple when you know how!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply