May 24, 2012 at 1:52 pm
Hi,
I've SQL Server Cluster with two nodes (A and B) and IBM DB2!!! I did a package (SSIS) to load data from DB2 to SQL!!! In my desktop works fine, but when I schedule the package, the job's fail with following error:
Executed as user: CORP\F023606. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 15:56:10 Error: 2012-05-24 15:56:10.91 Code: 0xC0047062 Source: Data Flow Task ADO NET Source [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, RetCode retcode)......
the ODBC Drive for DB2 it's x64, the package is configured to x64 ODBC well as the execution option tab for step of job don't use 32bit runtime!!!
obs.:
01-when this package is executed on sql server (no cluster) works fine!!!!
02-both nodes is configured system DSN to DB2 x64
any idea?
May 25, 2012 at 6:43 am
I found an alternative solution: to use OLE DB connection instead of ODBC Connection!!!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply