Enviroment:
OS: Windows 2003
DB: SQL 2000
Overvew:
DTS using ODBC to Sybase for capturing data from 13 separate tables and dump them into 13 different .csv files. Each task run concurrently. Total output of these 13 files are around 300Mb. A final task will compress the files into a 30Mb zip file. The dts is scheduled daily.
Normal execution will require slightly more than 1 hours.
The Sybase is being refreshed 5 times a day, each refresh require around 30-45min. During the refresh, the connectivity to the sybase will drop.
Problem:
1. Since migrated from SQL 7.0 to SQL 2000, The DTS has been on and off having problem. Sometimes, it will run for more than 3 - 5 hours. When i checked on the .csv file, one of the file is currently being adding with data at infinite loop. Causing the file size reaching more than 1Gb.
Temporary Solution:
1. Rerun the DTS, using scheduler.
OS: Windows 2003
DB: SQL 2000
Overvew:
DTS using ODBC to Sybase for capturing data from 13 separate tables and dump them into 13 different .csv files. Each task run concurrently. Total output of these 13 files are around 300Mb. A final task will compress the files into a 30Mb zip file. The dts is scheduled daily.
Normal execution will require slightly more than 1 hours.
The Sybase is being refreshed 5 times a day, each refresh require around 30-45min. During the refresh, the connectivity to the sybase will drop.
Problem:
1. Since migrated from SQL 7.0 to SQL 2000, The DTS has been on and off having problem. Sometimes, it will run for more than 3 - 5 hours. When i checked on the .csv file, one of the file is currently being adding with data at infinite loop. Causing the file size reaching more than 1Gb.
Temporary Solution:
1. Rerun the DTS, using scheduler.