SSIS Package Hangs - SQL Server Forums

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)

SSIS Package Hangs

Author

Topic

rds207
Posting Yak Master

198 Posts

Posted - 2010-03-19 : 00:31:00

Hi

i have 2 packages

1. first Package gets data from one database into Temp Table
2. Second package gets diff data from Temp Table to main table,
both temp and main tables are with same DDL...

First Package runs pretty fast and gets around 500k rows which is like past 7 days worth of data in my table
Second package while getting the Data from Temp table gets hangs up , just sits there in Yellow color no error message is displayed , this has been waiting for more than 12hrs,

I run a stored procedure to get the data from Temp table to main table,

Here is the Syntax of SP
ALTER PROCEDURE [dbo].[Proc_DiffData_EC_JOB]
AS
BEGIN

SET NOCOUNT ON;

ALTER PROCEDURE [dbo].[Proc_DiffData_EC_JOB]
AS
BEGIN

SET NOCOUNT ON;

Select * from dbo.DW_T_EC_JOB_TEMP where dbo.DW_T_EC_JOB_TEMP.EC_STEP_ID not in
(select EC_STEP_ID from DW_T_EC_JOB where (dbo.DW_T_EC_JOB.EC_STEP_ID = dbo.DW_T_EC_JOB_TEMP.EC_STEP_ID))

END

I tried to google around and tried different options

option 1 , tried to remove * and added all the columns in the select list
option 2 , tried to change the Transaction property to required for the dataflowtask
Option 3, Created the tables and packages , Jobs all over again :-(

all of them did not work ,

This packages actually worked fine when i initially created, i dont undertand what happened since last 3-4 days back it started hanging , and all other tables which are dependent on this paticular table also started hanging as this package runs continously for days,

Any suggestion is highly appreciated ...

Please Help ,

shirazaboy
Starting Member

2 Posts

Posted - 2010-03-19 : 12:11:20

Try deleting all the connections and redo them again... that helped me

rds207
Posting Yak Master

198 Posts

Posted - 2010-03-19 : 12:52:07

i did, but it did'nt help....:-(

Hey i have inserted the Data manually i mean by insert statement giving the same syntax to select the Data from Temp,

After inserting the Data , i ran my Package just to see if it works, and it quickly executed(as there is no new data to load i guess), without any hanging ...i looked into the data and data was pretty fine , i cannot understand what makes it hang while loading the data into Main table Via package.......

quote:
Originally posted by shirazaboy

Try deleting all the connections and redo them again... that helped me

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources