Problem with schedulling dts

[AnaFlor]

Hello,

I scheduled a dts, but when my dts is running by it, it gives me the following error:
The job failed. The Job was invoked by Schedule 55 (TEST). The last step to run was step 1 (TEST).

What is the problem? Can you help me?

Thanks

 

[JayKusch]

That error only tells us what SPID, process, and what step failed. It does not give us enough info to determine what the issue is.

You need to right click on the job that the DTS package created and then expand the steps to see if there is any more info we can gain.

If there isn't, you need to enable logging to a text file to capture more info. So open your DTS Package and once you are in the designer, choose Package..Properties..Logging from the menu bar. In there you will see at the bottom an area Error Handling section and a place to create the error file to disc. Set this up, run your package/job again, and relay your results.



Thanks

J. Kusch