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! :)
asked Apr 30 '12 at 11:34 PM in Default
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
answered May 01 '12 at 09:21 AM