I am trying to build a generic ssis package that can process xml files
in a directory. Each xml file has a different schema, which is part of
the xml file. I am using the access mode: XML file from variable and
using inline schema. In design mode I have to actually point the
variable to a valid and existing xml file. During runtime I am
dynamically populating the variable. When the package goes to process a
new XML file with a different schema from the one used in design time it
fails. Is there a way to accomplish this without writing a custom source
component??



*** Sent via Developersdex http://www.developersdex.com ***

Unfortunately not.

The Core to SSIS is that the buffers i.e. the columns in a data flow are
defined at design time. In your situation you want to be able to change
these at runtime, which isn't possible.

Your best solution is to design a flow for each type of schema and then
identify the schema in the loop and ecxecute the relevant data flow

--
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons

"Sara Nortrup" <meredith_sara (AT) hotmail (DOT) com> wrote

Just to add to what Simon has said. Even if you were to write a custom source
adapter that read the file at runtime and then managed to produce an output
that represented the changed XML file you would also need to change the downstream
components at runtime to recognise the new output as they would still be
bound to the old metadata.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com