SSIS how-to

=============================================================

Note: Configurable XML / XSD Location

=====================================

In your 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.

Create 2 Variables: one to hold XML location,

one to hold XSD location.

Bring up its properties (right-click > Properties)

Click the elipsis button next to EXPRESSIONS

Select the [XML Source].[XMLdata] 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.

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.

Click OK

Click OK again

Now add an Expression to each of the the Variables,

so that they evaluate to /XML/

OR for XSD files:

/XSD/

==============================================================

Note: When Packages Expect RAW FILES to Always Exist

When using RAW Files for staging, I found that the packages would expect the Raw Files to already exist, otherwise a runtime error occurs.

So if I change the format of the Raw Files, I need to update this location,

and update local files by running a MSDOS batch file.

Alternatively I can repeatedly run the packages until the raw files are created / updates

but this is not ideal. To do this, need to disable some later Data Flow Tasks,

until the earlier Data Flow Tasks have updated their Raw File outputs.

==============================================================