Skip to content
- Creat two variables with string data type in the package,set the default values as xml file path and xml schema path
- In CONTROL FLOW tab, select the data flow step that contains the XML Source step (Do not go into the dataflow, it must be done in control flow).
- Bring up its properties (right-click > Properties)
- Click the elipsis button next to EXPRESSIONS
- Select the [XML Source].[XMLSchemaDefinition] property then hit the elipsis button to the right of the Expression textbox.
- Drag and Drop your variable that holds your XSD path into the expression box, you should be able to evaluate expression here.
- Do similar to XML source file
- Click OK
- Click OK again
- Done
Comments