SSIS execution error

  • HI,

    I made an SSIS package in my desktop which is a 32 bit OS and tried to execute it on a server which is a 64bit os. I get a one page error which as a line like this.

    An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

    vallabh

  • Most likely you don't have 64bit drivers to that OLEDB source/destination.

    Regards

    Piotr

    ...and your only reply is slàinte mhath

  • there are some other jobs running on the same server with this type of connection

  • Then it seems that you have to compare them and look for differences. I had this kind of error when provider was not available for 64bit.

    HTH

    Piotr

    ...and your only reply is slàinte mhath

  • i made it!.

    it does not seem to be a 32/64 bit issue. The provider was using a MSDORA for oracle connection. when I changed it to OraOLEDB.Oracle. it worked

    😎

  • So it was a 64bit drivers issue.

    Piotr

    ...and your only reply is slàinte mhath

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply