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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2012-01-16 : 05:23:39
|
| Hi,In the SSIS, the connection manager was already configured to pull data from the DB2 environment, This is the package created by someone, and no idea how they configured it. On opening the connection manager, the following error msg is thrown."The specified provider is not supported. Please choose different provider in connection manager" and on clicking Ok, the Connection Manager dialog box opens, with the following info. Provider => .Net Providers for Oledb, OLE DB Provider => blank and the rest of the edit box are disabled with appropriate values filled in, excluding password (cannot be entered). Is there a way where we can identify the correct provider and if not available, can you please tell the provider that can be installed in the machine. Given below is the source code for this connection manager.<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">dbmidas.rgbmrusr.NET</DTS:Property><DTS:Property DTS:Name="DTSID">{CD344F68-AAC4-46E9-B4D5-6096AE321EB7}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">ADO.NET:System.Data.OleDb.OleDbConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="Retain">0</DTS:Property><DTS:Password DTS:Name="Password" Sensitive="1"></DTS:Password><DTS:Property DTS:Name="ConnectionString">Data Source=dbmidas;User ID=rgbmrusr;Provider=IBMDADB2.1;Persist Security Info=True;Location=midaspa1.services.us.ml.com:40000;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>I just created a sample connection manager using the ADO.Net Provider, after successful configuration it uses the Provider=IBMDADB2.DB2COPY1, which is nothing to do with the above mentioned provider I believe.Thanks in advance.Thanks,Chandra |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
SSIS - IBMDADB2.1 Provider