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
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