August 13, 2010 at 4:08 pm
Hello, I've got a SSIS package that will run in BIDS...but fails when I run it from sql server agent. Here is part of the error: The 'IBMDADB2.DB2COPY1' provider is not registered on the local machine
Why would it run successfully in BIDS and not from the sql server agent job??? The package runs fine through sql server agent in QA (dtsx/xml config file). Any help is fully appreciated.
Here is the full error message:
OnError
Data Flow Task To Load Tables
{5D9720BB-E786-41BC-B919-6A73982BB73E}
{C42C8E95-533D-44B6-9D46-3B62D16BED56}
8/13/2010 3:21:58 PM
8/13/2010 3:21:58 PM
-1073450910
System.InvalidOperationException: The 'IBMDADB2.DB2COPY1' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, 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, Object transaction)
August 13, 2010 at 5:40 pm
Does QA happen to be a 32-bit install (OS/SQL) vs. production being a 64-bit install?
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
August 16, 2010 at 11:48 am
OS & sql server in both QA and prod are 64 bit.
August 16, 2010 at 12:35 pm
I think it is a security issue related to permissions on the directory containing the DB2 Provider (IBMDADB2.DB2COPY1).
If your package uses a Run As user for data access services, the Run As user needs the Read and Execute permissions fo the directory containing the driver(s).
August 16, 2010 at 1:23 pm
That was it...a permissions issue to the DB2 directory. Thank you soooo much.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply