May 23, 2003 at 6:43 am
Howdy
Problem, after moving a db from a secure server to a less secure server the jobs needed (scheduled dts) to grab data from the secure server fail with:
Error: -2147220499 (800403ED); Provider Error: 0 (0)
Error string: No Steps have been defined for the transformation Package.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 700
Able execute the DTS manually fine from Ent. Manager; cannot run fine (same error) from query window. We have a lot of hands in the pot and permissions are always an issue; but the dba's on both sides aren't working and playing well together. What can I tell them to look at because running this manually every morning is a pain.
Thanks
D
May 26, 2003 at 8:00 am
This was removed by the editor as SPAM
June 9, 2003 at 9:31 am
The error message seems to indicate that the DTS package cannot find anything to do under the Transfromation Task. I would suggest that your DBA test the transfromation Task and make sure a) Transformation Task has steps in it and b) All steps are defined properly and function correctly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply