Hi,
Environment : SQL Server Intergration Services Beta 2.

Requirement is that moving the contents of all CSV files in a
particular folder to multiple tables in database.

What we have done so far.

In the Control Flow task we have used the Data Flow Task in Foreach
Loop Container in order to loop through all the files in the specified
Folder, then once all the files are read from that folder, the files
are copied to another folder and deleted from the source.
We have used the Script Component to transform the data to the DB.


What we need.

How do we specify the path of the folder dynamically to the Flat File
Source component. ( Or is there any other way to do this?)
How do we see to it that the database connection string is read at run
time. The DB will obviously change once the SSIS package is deployed.
Hence the DB cannot be hard coded.

Thanks in advance,
Soni

I'd suggest you use configurations. You would set the folder and the DB on
your connections through these.

See Configurations in Books Online, and they are forum on the SSIS menu in
BIDS.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"TechFreak" <soni.somarajan (AT) wipro (DOT) com> wrote