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"