Need SSIS package to process all XML files in a directory and archive them when finished

Hi folks,

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.
LVL 1
hennessymAsked:
Who is Participating?
 
PedroCGDCommented:
Use a script task to check if the folder exists and if nor create via imports sistem.IO
helped?
regards,
Pedro
www.pedrocgd.blogspot.com
0
 
hennessymAuthor Commented:
Thanks - do you have any sample code?
0
 
PedroCGDCommented:
Take a look to the package I made here and customize a little:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_24329323.html
Helped?
Regards,
Pedro
www.pedrocgd.blogspot.com
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.