Database password in BIML code

Hi!

 

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

 

Thanks in advance.

0

Comments

4 comments
  • Can you elaborate what you mean? 

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • 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.

     

    0
    Comment actions Permalink
  • ...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.

    0
    Comment actions Permalink

Please sign in to leave a comment.