Posted Thu, 30 Jan 2020 19:59:33 GMT by

Hi!

 

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

 

Thanks in advance.

Posted Sat, 01 Feb 2020 04:48:22 GMT by

Can you elaborate what you mean? 

Posted Sat, 01 Feb 2020 16:21:33 GMT by

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 05:52:32 GMT by

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 05:57:33 GMT by

...in 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.