x

SSIS Package to sort file uploads to specified locations

I have a SSIS package which loads spreadsheets from a Orders to Upload folder to a specified table. Once the file is uploaded successfully, the file goes to one folder which is a chain company folder name. ie.) Bev Mo Orders. We have added some chains to this process and would like to move the file once loaded successfully based on the file name. So if the file is like Bev Mo* then move to Bev Mo Orders, if like Costco* then move to Costco Orders.

I'm wondering what the best route to go with this is. Any information would be greatly appreciated! :)
more ▼

asked Apr 30, 2012 at 11:34 PM in Default

Noonies gravatar image

Noonies
1.2k 60 64 65

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

If you use the file system task after you have completed what you want to do, you can then use the Move File operation. If you set a variable as the destination you can set the variable to be the file name + Orders.

Hope this helps
more ▼

answered May 01, 2012 at 09:21 AM

Mrs_Fatherjack gravatar image

Mrs_Fatherjack
4.7k 60 62 66

Hi Annette,

Thank you for your response! Should I set the Move File within the file system task in a loop container so that it searches multiple variable names. For ex.) If the file is Bev Mo* then move to Bev Mo folder, If the file is Costco* then move to Costco folder, etc etc.
May 01, 2012 at 11:16 PM Noonies
That's how I've done it but I didn't know if you were processing them individually, this is the more efficient way though.
May 02, 2012 at 07:35 AM Mrs_Fatherjack
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x941

asked: Apr 30, 2012 at 11:34 PM

Seen: 768 times

Last Updated: May 02, 2012 at 07:35 AM