I'm new to SSIS so bear with me...
I'm trying to create an SSIS package to process all XML files in a directory and archive them when finished.
Basically I'd like the package to create a currentdate subfolder (Archive\CurrentDate\) if it doesn't already exist and then move the files as they're processed to that subfolder.
I have the XML Source and my OLEDB destination inside a ForEach Loop Container, but how do I test whether a directory exists, create one if necessary, and move the files?
Thanks in advance.