August 9, 2012 at 6:39 pm
I have created a package to import data from db2 using ibm ole db2 provider for db2. I provided the required user name and password for the adapter and therefore I am able to pull data from db2 when I run the package manually. Unfortunately the package failure when executed as a job by SQL server agent. I get the error posted below. I created a configuration file and embedded the password but the package still fails when it runs as a job. Any help will be very much appreciated.
Source: get_and_put Connection manager "SOURCE_DB2"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80040E4D Description: " SQL30082N Attempt to establish connection failed with security reason "3" ("PASSWORD MISSING"). SQLSTATE=08001
August 9, 2012 at 6:44 pm
Have you run through this doc from IBM on the error message?
http://www-01.ibm.com/support/docview.wss?uid=swg21175923
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 10, 2012 at 12:13 am
Is it possible to post the configuration file? (replace sensitive info with dummy values)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply