Posted Thu, 30 Jan 2020 14:59:33 GMT by Roman Horoshko



Is there any way to NOT store sensitive database connection data (user\password) in BIML scripts?


Thanks in advance.

Posted Fri, 31 Jan 2020 23:48:22 GMT by Varigence Support

Can you elaborate what you mean? 

Posted Sat, 01 Feb 2020 11:21:33 GMT by Roman Horoshko

I mean storing usernames and passwords to the connections outside of BimlScripts and metadata and not keep them as plain text.

For example when we do not have windows authentication access to the source and\or destination server in generated SSIS package.

Posted Mon, 24 Feb 2020 00:52:32 GMT by corey lawson

if you're using the old Package Deployment model, you'd just create a .dtsConfig file that contains the property values for your connection manager.  

For new Project deployment model, i think you need to create project properties, set the values for these, and apply them to the connection manager.


Posted Mon, 24 Feb 2020 00:57:33 GMT by corey lawson other words, if you're working with a SSIS package using Package Deployment model, first set up the package so it uses a .dtsConfig file that contains the username and password for your connection manager. Then, using BIMLExpress, convert your package to BIML. BIMLExpress should create the BIML file with the appropriate info and XML elements for the package to use the .dtsConfig file. When you then regenerate the the package from the BIML file, voila, SSIS will then configure things on whatever is in a given .dtsConfig file.

You must be signed in to post in this forum.