SSIS with IBM OLE DB Provider for DB2 (SQL Command data access mode)
I have SSIS package which gets the data from DB2 servers, and I am using "IBM OLE DB driver for DB2" in source connection provider, which is mandatory to use in my case. And my data access mode is "Sql command". When I clicked on columns in OLE DB source , I am getting the following error message. But its working fine when i select data access mode as "Table\view". Please help me in this as soon as possible. Please look at the following error description. ************************************************************************* Error at Data flow task [OLE DB SOurce]: An OLE DB error has occurred. Error code: 0x80040E21. (Microsoft Visual Studio) =================================== Exception from HRESULT: 0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData() at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata() at Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.connectionPage_SaveConnectionAttributes(Object sender, ConnectionAttributesEventArgs args) Sateesh Maduri
November 18th, 2010 12:36pm

Hello, Try to do the same but using a linked server: http://www.sqlcoffee.com/Tips0013.htm Hope this helps. Regards, Alberto Morillo SQLCoffee.com
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 11:33pm

Hi Sateesh, Could you please check if the SQL Command is working in DB2 server? Thanks, Jin ChenJin Chen - MSFT
November 24th, 2010 1:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics