DTS Package won't complete
Posted on 2006-05-19
I have a package that connects to a MainFrame using CA-Datacom ODBC.
When ran using SQL EM, the job runs fine and exits.
When ran as a job however, the package stay's locked on the job - but it does finish the entire set.
My job writes a date/time - then performs the ODBC transformation - then writes a date/time - then exits.
When ran as a job, this entire process completes - but the job doesn't exit and move on... Several hours later will still say "Executing Step 1"
Anyone see something like this?