Looping through datasource using Dynamic Properties task - 12-04-2006 , 04:37 PM
I have read hard through both SQLDTS.com and this forum but still can't
make it work together .
My problem is trivial.
I need to transfer data from a number of identical MS Access mdb
databases into an MS SQL Server db via DTS. I need to open the first
mdb, transfer data, go to the second mdb, transfer data, etc in a loop.
I store paths to mdb files in a table on the SQL Server and use Dynamic
Properties task in order to change the data source.
However what I miss is a clear picture of how the dts should look like.
Are Dynamic Properties task, Source Connection and Destination
Connection enough for that? Or do I need a global variable and ActiveX
task in order to organize a loop through data sources?
Maybe somebody has a description of the dts that is similar to mine and
uses Dynamic Properties task (or ActiveX and global variable)? I would
very appreciate that, thanks!
Re: Looping through datasource using Dynamic Properties task - 12-04-2006 , 04:44 PM
Hello alex.barvenov (AT) gmail (DOT) com,
The Package should look similar to this
You swap out the Flat File connection for the access connection
You do not need a dynamic properties task I would simply set the DataSource
property of the Access Connection in the Script task.
You need to loop over a rowset so it would look similar to
T +44 7966 476 572
F +44 2071 008 479