JenniferCheng
Programmer
I got two problems of DTS:
1. When I use DTS to move all records from one database to another database, only some records are moved, others not. And there is no error in the log file of export package and run status is 4 for this step. But I test transformation using “transformation data task properties”, it shows all the records are moved from original table to a text file. I can not find any error in SQL query of this task.
2. In this DTS export package, I design many tasks. When processing step 5, it always stops at “run time is 0”. Then the whole export stops and no more data export. What is meaning of “run time is 0”? How to solve it?
Thanks.
1. When I use DTS to move all records from one database to another database, only some records are moved, others not. And there is no error in the log file of export package and run status is 4 for this step. But I test transformation using “transformation data task properties”, it shows all the records are moved from original table to a text file. I can not find any error in SQL query of this task.
2. In this DTS export package, I design many tasks. When processing step 5, it always stops at “run time is 0”. Then the whole export stops and no more data export. What is meaning of “run time is 0”? How to solve it?
Thanks.