July 2, 2005 at 11:00 pm
I have written an elaborate DTS package to transfer data from our main processing database (Pervasive/Btrieve) into SQL Server. Many 4GL applications written in Btrieve would create a new database to store a years data in. We have database running from 1995 through 2005, that's 10 connections. Plus I have sets of years for corporate entities. There are just a lot of database connections.
What I would like to do is be able to call this DTS package many times from another DTS package, preferably using a vbscript task. The ODBC hooks are consistent: myApp2000, myApp2001, myApp2002, etc. Since I need to run this DTS package for each of these connections, I would like to parse the connection name write it to a global variable or something and execute the DTS package. When it is done, I will switch to the next year (connection) and run it again until I have done them all.
I guess what my question is in a nutshell is, how do I call a DTS package from vbscript so I may recall it again and again in a loop?
Any other approaches are always welcome. Thank you in advance for your assistance.
Brett
July 5, 2005 at 8:00 am
This was removed by the editor as SPAM
July 5, 2005 at 12:05 pm
Brett,
Take a look at this link - it should answer your questions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply