none
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D

    Question

  • I get the error below when I execute my SSIS (2008) package in BIDS 2008 -

    [Execute SQL Task] Error: Failed to acquire connection "MyDatabase". Connection may not be configured correctly or you may not have the right permissions on this connection.
    
    [Connection manager "MyDatabase"] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.
    An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'MyUSer'.".
    

    I tried everything I could, but no success in fixing it so far. I tried -

    1 - Encrypt sensitive (or all) with a password. 2 - Dont save sensitive and load connection settings from a package config file instead.

    How do I fix this thing ? My package was working fine before I put some of its components in a sequence container and then set the containers "transactionOption" to "Required"

    Saturday, November 09, 2013 8:47 PM

Answers

All replies