Posted - 03/22/2013 : 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 
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