"TechFreak" <soni.somarajan@wipro.com> wrote in message
news:1135084476.546476.235890@g49g2000cwa.googlegroups.com...
> 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
>