February 14, 2008 at 6:34 am
Hi all,
I have weird problem with my SSIS job.
I have file based SSIS package and i am running on bat file in command prompt in SQL job. but some times the job never ends. when i see in Services the DTEXEC.exe*32 keep running. but the job keeps running. I am not getting any error message in event view or any logs!! what should i do!!
Is there a script that i can run for the job to stop if it is running more than 30 min???? please help!!
February 14, 2008 at 6:51 am
put logging on your SSIS package and view the output.
February 14, 2008 at 7:16 am
I have and after some packages goes fine and then it get stuck on one. but most of the time it goes fine through out!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply