StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This steps is for creating an XML configuration file (.dtsConfig) which can keep your sensitive data, like the password of your connection string, without having a Protection Level that can make you difficult to move the package from one machine to another.</p> <p>In this example, assumed you have an OLE DB Connection to an SQL database called MyDb.</p> <ol> <li><p>Control Flow, Property: set "ProtectionLevel" to "DontSaveSensitive"</p></li> <li><p>Control Flow, right-click empty space to get menu: click "Package Configuration"</p></li> <li><p>Package Configuration Organizer: tick "Enable package configuration"; click "Add"</p></li> <li><p>Package Configuration Wizard, Select Configuration Type: set "Configuration type" to "XML configuration file"; choose "Specify configuration directly" radio button; click "Browse..."</p></li> <li><p>Select Configuration File Location, fill "Filename": [PackageName].dtsConfig (easy if same folder and same filename as the package itself, just different extension); click "Save"</p></li> <li><p>Package Configuration Wizard, Select Configuration Type: click "Next >"</p></li> <li><p>Package Configuration Wizard, Select Properties to Export: traverse the following tree nodes and tick its checkbox; click "Next >"</p> <p>\[PackageName]\Connection Managers\MyDb\Properties\Connection String</p> <p>\[PackageName]\Connection Managers\MyDb\Properties\Password</p></li> <li><p>Package Configuration Wizard, Completing Wizard, click "Finish"</p></li> <li><p>Package Configuration Organizer: click "Close"</p></li> <li><p>Solution Explorer: right click the root tree for menu, click "Add", "Existing Item...", click [PackageName].dtsConfig, click "Add"</p></li> <li><p>Solution Explorer: double click \Miscellaneous\[PackageName].dtsConfig to load into editor;</p></li> <li><p>Main menu: click "Edit", click "Advanced", click "Format Document"</p></li> <li><p>Traverse the XML tree node: \DTSConfiguration\Configuration[Path="\Package.Connections[MyDb].Properties[Password]"]\ConfiguredValue; key in the database password; save the file</p></li> <li><p>Windows Explorer: navigate and double click [PackageName].dtsx</p></li> <li><p>Execute Package Utility, Configuration, click "Add", double click [PackageName].dtsConfig, click "Execute"</p></li> </ol> <p>When required to move the .dtsx to another machine, simply accompany it with its .dtsConfig. Hope this helps.</p> <p>Cheers, Ari.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload