Configuring XML source in SSIS Project deployment method

Question

I am working on the deployment and configuration of an SSIS project deployment package (SQL 2012). The package reads data from an XML.

In the data flow task XML Source does not have an Expressions property that I could easily use to configure the source file path using a parameter, nor does it take an XML file connection.

In the package deployment I used to be able to set any property value using the config file as a workaround; it looked like this:

<Configuration ConfiguredType="Property" Path="\Package\Preparation and Staging\Load data into Staging table.Properties[[XML Source].[XMLData]]" ValueType="String">
  <ConfiguredValue>D:\Folder\SourceFile.xml</ConfiguredValue>
</Configuration>

Is there any way to achieve this when in project deployment method?

Answer 1

Actually, XML Source does have a property for specifying XML Source. Two pictures instead of 100 words.


Red rectangle shows properties you can use for dynamic configuration of XML Source. These properties have corresponding Expressions.