Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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

Very Important crosS Applying yaK Herder

52326 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

Go to Top of Page
  Previous Topic Topic Next 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.03 seconds. Powered By: Snitz Forums 2000