SSIS package works in VS but failed in SSMS

  • 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.".

     

  • 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 1 (of 1 total)

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