Can someboy tell me is it possible to generate XML using SSIS script task and SSIS variables (not from SQL table but if not possible then ...)???
The xml which is supposed to be build has multiple nodes. eg. Parent Node->Child Node->Child Node.
I have to use SSIS variables, During Runtime the variables will be populated will data and this has to added in the xml..Any help will be highly appreciated.