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.
| Author |
Topic |
|
latture
Starting Member
24 Posts |
 Posted - 2013-03-22 : 09:42:05
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-22 : 13:32:32
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
Error code 0xC0047062