Friday, 27 February 2015

How to use XML task(XSLT tranformation) in a for each loop and write the tranformed files to another folder?



I am trying to use for-each loop in SSIS 2012. The purpose of the package is to loop through a folder with xml files as input, process them using xml task (for XSLT transformation) and write all the processed files to another folder.


I am able to do the xml task with single file (Source type: File Connection) and get result.


When using in for each loop, I am able to pass in the files into xml task using the loop variable and make the package run, but when I use the file system task to write the processed files it is copying just the processed files.


I am unable to think what was wrong with the process.


Any ideas would be greatly appreciated.


I even tried just with a single file for xml task and pass it in as variable (not in for each loop), it transforms that, but when I use for-each loop, it is not doing and unable to write the processed files.


No comments:

Post a Comment