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.
Comments
You can make a connection file and use CallBimlScript(). Here is a more in depth article describing CallBimlScript and how it works:
https://www.cathrinewilhelmsen.net/2015/02/23/dont-repeat-your-biml-callbimlscript/
Please sign in to leave a comment.