Posted Mon, 12 Mar 2018 23:54:37 GMT by jacob alley

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/

Posted Mon, 03 Dec 2018 18:38:00 GMT by
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.

You must be signed in to post in this forum.