Hi!

I would like to open XML file in DTS and then parse it and save it content
in a few rowsets.

So I put a Dynamic Properties Task in my package, within it I read the
content of XML file into the global variable. Next I created an Execute SQL
Task and wanted to use it to prepare XML document using "EXEC
sp_xml_preparedocument @idoc OUTPUT, @doc" which is required for OPENXML
statement. However how to use global variables with sp_xml_preparedocument?
I tried to put "?" instead of its arguments and then map it to global
variables however I get "syntax error or access violation" when I click
parameters button.

So what's the correct way to use global variables in such situation? Or
maybe there is a better way to handle XML files within DTS?

Regards
Silmar