Dynamic connection database for easy maintenance
Implementing with SSIS Package configuration
1. Control Flow tab-right-click-Package configuration
2. Configure the XML file
3. Specify connection properties: ServerName, UserName, Password
Test:
1. Configuration Error
2. Correct configuration
1 <?XML version= "1.0"?><dtsconfiguration><dtsconfigurationheading><DtsconfigurationfileinfoGeneratedby= "Joe-pc\joe"Generatedfrompackagename= "HRPC"Generatedfrompackageid= "{6403cc76-1e3c-4f05-a51b-69c1acfcae38}"generateddate= "2015/9/17 10:33:03"/></dtsconfigurationheading>2 3 <ConfigurationConfiguredtype= "Property"Path= "\package.connections[wave gs". Properties[password] "ValueType= "String"><ConfiguredValue>Aaaaaa</ConfiguredValue></Configuration>4 5 <ConfigurationConfiguredtype= "Property"Path= "\package.connections[wave gs". Properties[servername] "ValueType= "String"><ConfiguredValue>192.168.8.4</ConfiguredValue></Configuration>6 7 <ConfigurationConfiguredtype= "Property"Path= "\package.connections[wave gs". Properties[username] "ValueType= "String"><ConfiguredValue>lc0019999</ConfiguredValue></Configuration></dtsconfiguration>
View Code
SSIS package configuration dynamic configuration database connection