SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Error code 0xC0047062
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

latture
Starting Member

24 Posts

Posted - 03/22/2013 :  09:42:05  Show Profile  Reply with Quote
I have an SSIS package job that's scheduled to run twice a day, once around 11pm then again at 5am. The 11pm runs fine but for the last week the 5am job fails. We did have an update in our server from 2008 to 2008 R2. Does anyone have any clue to why one works but the other doesn't? They both run the same SSIS, the only difference between the jobs is the time... Below is the error that I retrieved from the log.

03/21/2013 05:15:00,Import CW Host Company to Central_Bulk_AM,Error,3,RPISQL,Import CW Host Company to Central_Bulk_AM,central_bulk.cwhc.STKPARTS - Import,,
Executed as user: LR\SSAG. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 5:15:00 AM Error: 2013-03-21 05:15:01.60 Code: 0xC0047062 Source: Data Flow Task 1 Source - STKPARTS [1]
Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection<c/> OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/> DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection<c/> DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection<c/> DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName<c/> String connStr<c/> Object transaction)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper<c/> Object transaction)
End Error Error: 2013-03-21 05:15:01.60 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline
Description: component "Source - STKPARTS" (1) failed validation and returned error code 0x80131937. End Error Error: 2013-03-21 05:15:01.60 Code: 0xC004700C
Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-03-21 05:15:01.60 Code: 0xC0024107
Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1).
Started: 5:15:00 AM Finished: 5:15:01 AM Elapsed: 0.998 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0

Edited by - latture on 03/22/2013 12:09:33

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/22/2013 :  13:32:32  Show Profile  Reply with Quote
Seems like problem with ODBC source connection availability. Check source to which its trying to connect in Source - STKPARTS step within package and check its availability at 5am

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000