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