April 4, 2008 at 6:30 am
hello,
Iam running a ssis package to import data from db2 to sql server table. I jus used a sql task n dataflow task.when I ran the package Iam getting following errors.
1.[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Cannot get the column information from OLE DB provider "IBMDADB2.DB2COPY1" for linked server "DB2PROD".". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The OLE DB provider "IBMDADB2.DB2COPY1" for linked server "DB2PROD" reported an error. Access denied.".
2[DTS.Pipeline] Error: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.
could you plz help me why Iam getting these errors n how to resolve them
thanks
April 4, 2008 at 8:08 pm
It looks like you are using a query across a linked server to the DB2 database in the Execute SQL Task. If this is true can you execute the same Query in SSMS?
Why not just use the OLEDB provider for ODBC or the IBM provided OLEDB provider and directly connect to DB2 from SSIS?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply