|
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! :)
(comments are locked)
|
|
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 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 '12 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 '12 at 07:35 AM
Mrs_Fatherjack
(comments are locked)
|
