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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SQLJob: A Step with SSIS Package data source issue

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?
Go to Top of Page
   

- Advertisement -