> 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!