[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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.
0
hennessym
Asked:
hennessym
  • 2
1 Solution
 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now