DB2 connection manager in ssis adding bin to the user name during run time

Question

Hi All,

DB2 connection manager in SSIS adding bin to the user name during run time.
Connection gets successful in test connections. It below error fails the package when I run it.

Error:

Exception from HRESULT: 0xC0202009
Error at df_Load [oledb_Source [2]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: ""usernameBIN" does not have the privilege to perform operation "".".

Answer 1

Hi @Anonymous ,

Welcome to Microsoft Q&A Platform. Thanks for posting here.

1. Please check if you have the appropriate privileges for the "Microsoft DB2 OLE DB Provider" to create and bind packages with your user ID.
2. These privileges are BINDADD for binding packages, CREATEIN on the collection specified by the Package Collection option, and GRANT EXECUTE on the PUBLIC group for executing the packages. These are typically the permissions of a Database Administrator (DBA).
   Please refer to Failed to connect to data source; does not have privilege to perform operation bind.

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Answer 2

Ran into the same issue while querying the linked server Microsoft DB2 OLE DB Provider for Db2. The user is added to the db2luw/udb database with CONNECT and DATAACCESS privileges but not BINDADD. You can use the user to connect to the linked server just fine but the query blew up with the statements below. Granting BINDADD to the user resolved the issue. Hope this helps someone else who has also ran into this issue. Thanks!

select * from LINKEDUDB_TEST.TESTUDB.SCHEMA.TABLE1

OLE DB provider "DB2OLEDB" for linked server "LINKEDUDB_TEST" returned message "One or more errors occurred during processing of command.".
OLE DB provider "DB2OLEDB" for linked server "LINKEDUDB_TEST" returned message ""DB2STGUSER BIN" does not have the privilege to perform operation "". SQLSTATE: 42502, SQLCODE: -552".
Msg 7330, Level 16, State 2, Line 319
Cannot fetch a row from OLE DB provider "DB2OLEDB" for linked server "LINKEDUDB_TEST".

And using Openquery got this:

select from openquery(LINKEDUDB_TEST,'SELECT FROM TESTUDB.SCHEMA.TABLE1')

OLE DB provider "DB2OLEDB" for linked server "LINKEDUDB_TEST" returned message ""DB2STGUSER BIN" does not have the privilege to perform operation "". SQLSTATE: 42502, SQLCODE: -552".
Msg 7321, Level 16, State 2, Line 323
An error occurred while preparing the query "select * from TFBUDB.AG_AGT_INFO" for execution against OLE DB provider "DB2OLEDB" for linked server "LINKEDUDB_TEST".