none
The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005

    Question

  • I export data from a dozen tables of one database to another database on another server regularly and it works well.  However, if i choose the option of "save SSIS package", I get the following error:

    TITLE: SQL Server Import and Export Wizard
    ------------------------------

    The operation could not be completed.

    ------------------------------
    ADDITIONAL INFORMATION:

    The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement issued has failed.


    ------------------------------
    BUTTONS:

    OK
    ------------------------------

     

    I use management studio to do this, but the servers are 2000.

    Does anyone have any clue about this?

     

    Monday, October 02, 2006 5:46 PM

All replies

  • I've got the exact same problem.  My guess is that you can't save SSIS packages on SQL Server 2000.  I'm just going back to the old enterprise manager and using my old DTS packages.  I know those work.
    Thursday, December 21, 2006 11:50 PM
  • I don't think so as it appears to me even I have 2005.

     

    Monday, April 14, 2008 2:24 PM
  • Could this be an Express problem?

    Saved the SSIS package as file and it ran.


    {-|-}

    • Proposed as answer by Ramesh Live Wednesday, November 28, 2012 7:46 AM
    Monday, October 15, 2012 4:28 PM