SSIS Package Failures - 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 2005 Forums

SSIS and Import/Export (2005)

SSIS Package Failures

Author

Topic

poser
Posting Yak Master

124 Posts

Posted - 2011-11-09 : 06:41:20

Good morning,
I have a package that fails intermittently and I think it is failing here with the Truncate and the Insert....Returns no error message anywhere.....
Is there a better way to do this?
Thanks for any help..
r/p

ELSE
BEGIN
Truncate Table TESTP.dbo.T_EDT
Update Statistics TESTP.dbo.T_EDT
INSERT INTO TESTP.dbo.T_EDT (SSN, NAME, DATE)
SELECT SSN, NAME, TESTP.dbo.fn_Convert_YYYYMMDD(DATE) as DATE
FROM RATE.dbo.T_EDT
WHERE TESTP.dbo.fn_Convert_YYYYMMDD(DATE) is not null

UPDATE TESTP.dbo.T_Load
SET EndDT = GETDATE()
WHERE TableName='T_EDT'
END

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-09 : 06:54:54

whats the error you're getting here?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

poser
Posting Yak Master

124 Posts

Posted - 2011-11-09 : 07:58:39

This is the only error...
No errors in SQL Logs
No errors in Event Viewer

Job History Error:
Step ID 21
Server TestServer
Job Name Daily - PM
Step Name Load TESTP - Dept
Duration 00:06:05
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: test. ...000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:20:42 AM Error: 2011-11-08 07:26:46.82 Code: 0xC002F210 Source: Load TESTP T_EDT Execute SQL Task Description: Executing the query "DECLARE @CNT int UPDATE TESTP.dbo.T_Loads SET StartDT = GETDATE(), EndDT = Null WHERE TableName='T_EDT' SELECT @CNT = COUNT(*) FROM RATE.dbo.T_EDT IF @CNT = 0 BEGIN RAISERROR('No Record in RATE.dbo.T_EDT.', 16, 1) END ELSE BEGIN Truncate Table TESTP.dbo.T_EDT Update Statistics TESTP.dbo.T_EDT INSERT INTO TESTP.dbo.T_EDT (SSN, NAME, DATE) SELECT SSN, NAME, TESTP.dbo.fn_Convert_YYYYMMDD(DATE) as DATE.... The package execution fa... The step failed.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-09 : 08:00:51

its not complete. can you copy and paste full error message please?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

poser
Posting Yak Master

124 Posts

Posted - 2011-11-09 : 08:06:54

That is all of the error message that shows up?

poser
Posting Yak Master

124 Posts

Posted - 2011-11-09 : 09:17:35

Same server another task failure:
I reran a minute later and it ran......

Log Job History (Daily - PM)

Step ID 30
Server TestServer
Job Name Daily - PM
Step Name T18
Duration 00:04:11
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: test. Microsoft (R) SQL Server Execute Package Utility Version 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:49:14 AM Error: 2011-11-09 08:53:25.57 Code: 0xC002F210 Source: Perform test Clearances Execute SQL Task Description: Executing the query "Execute T18.dbo.sp_test" failed with the following error: "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:49:14 AM Finished: 8:53:25 AM Elapsed: 250.593 seconds. The package execution failed. The step failed.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources