Informix ODBC and SSIS Package

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 2008 Forums

SSIS and Import/Export (2008)

Informix ODBC and SSIS Package

Author

Topic

damadbutcher
Starting Member

3 Posts

Posted - 2011-06-06 : 20:07:58

Hi

I have created a a 32bit Informix ODBC on a Windows 64x server that is used by SSIS to extract some data and populate into a SQL db. This package runs fine when I have the "Run64BitRuntime" set to false.

However when I schedule this job in SQL to run I receive the following error: Date 7/06/2011 11:45:36 a.m.
Log Job History (DC_Informix_Issue)

Step ID 1
Server FS-OLAPDEV
Job Name DC_Informix_Issue
Step Name DC_7 Protection
Duration 00:00:07
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: FS_DOM\SQLService. ... 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:45:36 a.m. Error: 2011-06-07 11:45:43.55 Code: 0xC0047062 Source: DFT_InsertDCRecords drs_EXCEED_IINVD [2257] 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, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.Provid... The package execution fa... The step failed.

I have been looking on the web for a resolution but so far unlucky. Any help would be greatly appreciated.

Steve

I am not a number

damadbutcher
Starting Member

3 Posts

Posted - 2011-06-06 : 20:11:02

Sorry I have posted this in the wrong forum.

I am not a number

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources