locked
SSIS Clustering Doubts RRS feed

  • Question

  • I have a SQL cluster 2005 with 2 nodes. I involved a ETL (DTS) on SSIS.

    I used OLEDB to get a connection ORACLE and INFORMIX.

    I used a user and password to authenticate.

    When I publish the package, to the Integration Services.

    I publish it to the MSDB so in case that we have a failover that the package is the same.

    However in case of switching server (failover) the package that I published on NODE 1 does not run on NODE 2.

    And it fail:

    OnError,EDVSQLCLUSTER02,DOMAIN-LISBOA\rolo,Insert pt_fornsap,{F06434D9-431B-48B7-A3E6-F17E04A29488},{4FF70682-705E-4410-885F-36F25BC1EC8C},22-09-2006 2:00:01,22-09-2006 2:00:01,-1071636471,0x,An OLE DB error has occurred. Error code: 0x80040E14.
    An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E14  Description: "Statement(s) could not be prepared.".
    An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E14  Description: "Invalid object name 'pt_lfa1'.".

    Could you help me

    Thanks for advance

    AG

     

     

    Monday, January 15, 2007 5:57 PM

All replies

  • Hi AG,

    Can you tell me what the object named "pt_lfa1" is?

    Thanks,

    Andy

    Tuesday, January 16, 2007 2:48 AM