ssis -- sql server dts

farshad
7/26/2007 4:12:03 AM

Hi,
I am using a foreach loop to go through the .txt files inside a folder.
Using a variable I can pickup the filenames the loop is going through.
At present there is a sql task inside the foreach loop which takes the
filename as a parameter and passes this filename to a stored procedure.
Now I would like to add one extra step before this sql task. Would like to
have a dataflow with flatfile source which connects to oledb destination.

The question is:
While in the loop, how is it possible to pass the filename to the flatfile
source using the FileName variable which I have created?

Please note, this is a different question to my other post.

Todd C
7/28/2007 10:24:02 PM

Hello farshad,
Not sure I understand all that is going on in your package, even after
reading both posts, but may have a suggestion anyway:

In the connection manager for the flat file source, look in the Properties
section. Look for the Expressions property. Set up a new Expression on the
ConnectionString property and set it to the variable.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : ssis