OLE DB Command Error SSIS

Hi,

when we are using OLEDB Command we are getting the following error?

when we use sql server as the source its working fine .but its throwing error when we try to connect the orcale database .

Error at Data FLOW TASk[OLE DB Command[3863]]: An OLE DB error has occured :0x80040E51.

An OLE DB record is available. Source : "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E51

Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".

ERrror at Data Flow Task [OLE DB Command [3863]]: Unable to retrieve destination column description from the Parameter of the SQL Command

Thanks & Regards

Jegan.T

This is an OLE DB Error. My first suggestion would be to try Oracle's own driver instead of the Microsoft one.

-Jamie

|||

Hi Jamie,

Do we need to install orcale driver separtely or its comes with SSIS ?

Thanks

Jegan.T

|||

Seperately. It comes with Oracle.

|||

Hi Jamie

Thanks for the suggestion . i'll give a try and get back to you..

Jegan.T