Dynamic ODBC Connection string in BIML script for SSIS package

How to call the connection string directly in the BIML script for SSIS package with username and password, so that I don't have to change the connection in all the BIML scripts? The problem I am facing currently is even though I am trying to pass the ODBC connection, it is creating the encryption of the password resulting in error.


1 comment

Please sign in to leave a comment.