Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS problem when scheduling as job

Status
Not open for further replies.

pgraves

Programmer
Aug 30, 2006
10
GB
Hi all,

I hope someone can help me with this as I am completely stumped.

I have a DTS package that uses an activeX script to loop through a bunch of files in a folder. The data in the files is then inserted into a table.

When running the DTS package from Enterprise Manager is runs perfectly fine. When I shedule the package to run as a job, the job begins executing but then just sits there. It never completes and never fails.

I am pretty sure it is not permissions related as this would give me an error. I even removed the input files so there was no processing to do and again the job just started executing indefinitely.

Any suggestions would be apreciated.

Thanks,
Paul
 
Hi Paul,

It's possible to switch logging onto your package (select package properties) in the design screen and select the logging tab. This may give you a clue in relation tohow far it's getting before it hangs.

Regards,
Tom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top