Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  problem with scheduled DTS package

Author  Topic  smatej Starting Member 1 Post Posted - 2004-10-29 : 04:33:22 I have a DTS package that works fine if I start it from EM. It has two steps. At first it truncates a table and then it fills it with data from Oracle. I scheduled it and I get no error when it executes but as the result I get empty table. As if only the first step would be executed and second step ignored. The message in job history is: "The step did not generate any output. Process Exit Code 0. The step succeeded." Any help would be most appreciated. Matej