Solved

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

Posted on 2009-05-07
3
230 Views
Last Modified: 2012-05-06
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
Comment
Question by:hennessym
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
PedroCGD earned 250 total points
ID: 24335354
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
 
LVL 1

Author Comment

by:hennessym
ID: 24336383
Thanks - do you have any sample code?
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24336479
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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question