A VB.NET component delivered following message:
Login failed for user MyDBUser
It is about an OleDbConnection.
btw The user works fine togehter with SQL Server Management Studio.
Retaining a password via the connection manager does not work even with enabling
Save my password.
In my case, it is not a security issue to retain the password because the SSIS package will not be published for others.
Hence, what's the fastest way -concerning the VB.NET code- to enable an access to the (SQL Server) password?
Workaround: A SSIS variable was attached to the scope of the required control flow.
Me.readVariable was applied to concat the connection string.