Dynamic ODBC Connection string in BIML script for SSIS package
Abhijeet
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.