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?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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