Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijay1234
Starting Member
48 Posts |
 Posted - 2014-09-08 : 23:01:01
|
| Hi friends,Here i'm facing a new challenge in my Prod Server.We have a scheduled job with 10 steps involved running ssis packages inside.The run time is hardly 20 minutes.Here at step#5 it is taking days of time but yet won't finish up completion.Checked the process using sp_who2 to know whether any transactions are blocking this step.It is noted that the prior steps involved SSIS package Data Source is performing 'UPDATE' (In Command column) is blocking the step completion.Program Name is 'Application Name=SSIS-XXXXX-{XXXXXXXXX}ABC.DEF;' ( This basically comes from the Datasource tab under every job step involved with SSIS package using Datasources)If we manually stop the job those processes are being removed automatically (with out using Kill option).Don't know how to solve this issue.Request some one to help me out if faced same kind of situation with possible solution.Regards,Vijay |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-09 : 08:24:02
|
I'm having trouble understanding what you mean by:quote:
The run time is hardly 20 minutes.Here at step#5 it is taking days of time but yet won't finish up completion.
Surely both things cannot be true at the same time?IN any case, can you please post the steps in the SSIS package for job step #5, along with the entire text of the query or queries run by that package? |
 |
|
|
|
|
|
SQLJob: A Step with SSIS Package data source issue