Hi,

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!

Hello alex.barvenov (AT) gmail (DOT) com,

The Package should look similar to this

http://www.sqldts.com/default.aspx?246


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

http://www.sqldts.com/default.aspx?298


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com