Please Help resove it inj SSIS

  • [Reset connections] Error: Unable to log in to the server. 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 quite clear: either you specified an incorrect connection string, or you (or the account executing the package) don't have the permissions.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This Error Comming in Execeuting Script task. i have all permission and also bulding packages in local.

  • anbu899 (10/16/2014)


    i have all permission...

    The error says otherwise...

    Can you share the code?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Check the DB connection in the Connection Manager.. There's an option "Test Connection"..

    If that works you should not be seeing this error.

    "The price of anything is the amount of life you exchange for it" - Henry David Thoreau

Viewing 5 posts - 1 through 4 (of 4 total)

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