Unanswered: Problem with DTS scheduleted job in SQL7
I have to transform data from SQL 7 to MySQL and I use the DTS for this task. This DTS consists of the 15 transform data tasks. There are different counts of records in the tables which are transformed. Some tables have only about 100 records, but some 30000 – 80000 records.
The problem is when I execute this DTS by scheduler as job. It doesn’t transform all records form tables with large count of records and DTS’s log file is empty! If I execute job of the DTS, which is composed of only one or two transform data tasks from tables with 30000 records, then job occurs correctly and log file is filled.
However, when I execute this DTS form the SQL Server Enterprise Manager console, all is OK absolutely!
There is feeling that some timeout interrupts a connection with out any error!
Vaman data server has a tool for data migration. It was useful to me I was able to migrate my data from access to mysql. It should work for you as well. go to www.vaman.net and download vaman data server. the direct link should be http://www.vaman.net/vmndataserver.htm