SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Understanding simple XML configuration code in dtsConfig file


Understanding simple XML configuration code in dtsConfig file

Author
Message
etl.laptop
etl.laptop
SSC-Enthusiastic
SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)

Group: General Forum Members
Points: 179 Visits: 116
<Configuration ConfiguredType="Property"
Path="\Package.Connections[AdventureWorks].Properties[ServerName]"
ValueType="String">
<ConfiguredValue>SomeServer</ConfiguredValue>
</Configuration>

I referred to the link - http://msdn.microsoft.com/en-us/library/cc671628.aspx
A configuration is supposed to be a name-value pair. The property is ServerName, and
its new value is SomeServer.


I am not able to understand how this works. I have the following questions -
What is ConfiguredType and why do we need to mention it ?
What does Path tell us ?
What is ConfiguredValue ?
How does SSIS read such files and "get everything ready for you to use" ?

thanks.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27221 Visits: 13268
* ConfiguredType=Property. This tells the configuration configures a property of some object.

* Path is some sort of location of the object you which to configure.
For example: "\Package.Connections[AdventureWorks].Properties[ServerName]"
You take the package, go to the connection called AdventureWorks and you take the property called ServerName. With this path, you'll configure the ServerName property of the package configuration manager called AdventureWorks.

* ConfiguredValue is the value with which you want to configure some object. For example, if you deploy your package to the test server, you'll enter the name of the test server here. If you deploy the package to production, you'll enter the production server name there.

You don't need to worry too much about the structure of the XML file. It is automatically generated for you when you complete the package configuration wizard.
In my personal opinion, SQL Server configuration tables are easier to use than XML files.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
etl.laptop
etl.laptop
SSC-Enthusiastic
SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)

Group: General Forum Members
Points: 179 Visits: 116
Koen Verbeeck (10/3/2013)
You don't need to worry too much about the structure of the XML file. It is automatically generated for you when you complete the package configuration wizard.
In my personal opinion, SQL Server configuration tables are easier to use than XML files.


Koen - I take it as an academic exercise. It might be good to know these things.

Koen Verbeeck (10/3/2013)
* Path is some sort of location of the object you which to configure.
For example: "\Package.Connections[AdventureWorks].Properties[ServerName]"
You take the package, go to the connection called AdventureWorks and you take the property called ServerName. With this path, you'll configure the ServerName property of the package configuration manager called AdventureWorks.


This made it seem that SSIS will go to "my Package" (how does it find the package to go to is another question), that is the Package.dtsx file.
Then, it will look for something like "Connection" and "ServerName" do the config. I did not find those 2 words anywhere in my .dtsx file.

Koen Verbeeck (10/3/2013)
* ConfiguredValue is the value with which you want to configure some object. For example, if you deploy your package to the test server, you'll enter the name of the test server here. If you deploy the package to production, you'll enter the production server name there.

stevefromOZ
stevefromOZ
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: Moderators
Points: 3448 Visits: 3757
There's a couple of reasons why you may not see (find) that property, the first one that comes to mnd is if your file is partiallly encrypted (typically done to protect info like connection details incl. User names and passwords).

If you are really (REALLY) interested in knowing more about the dtsx, the full xsd is documented here -> here

Steve.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27221 Visits: 13268
etl.laptop (10/3/2013)
[quote]Koen Verbeeck (10/3/2013)
This made it seem that SSIS will go to "my Package" (how does it find the package to go to is another question), that is the Package.dtsx file.
Then, it will look for something like "Connection" and "ServerName" do the config. I did not find those 2 words anywhere in my .dtsx file.


When you execute a package, you specify the xml config file, or you specify the xml config file in the package configurations window. Either way, SSIS knows in which package to set properties, because you tied that XML config file to a specific package.

Connection is called ConnectionManager in the .dtsx and the .dtsx doesn't store the properties seperately (such as ServerName), but it stores only the connection string. When you open the designer, BIDS parses the xml behind the package and populates the properties accordingly.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search