Post reply

SSIS package works in VS but failed in SSMS

  • December 2, 2024 at 10:15 pm

    #4492364

    Please help and thanks.

    Package:Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80004005  Description: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.".

     

  • December 3, 2024 at 9:47 am

    #4492545

    The error message seems clear. The connection from the SQL Server instance to the target server is different from the one from your machine. It could be a networking issue, a credentials issue or something else.

    Were there any other errors which might explain the problem in more detail?

Viewing 2 posts - 1 through 2 (of 2 total)

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