October 19, 2011 at 2:03 pm
I have a table called vendor with one column called VTaxID, which store a list of vendors taxid.
I have folder called Source under D:\. The folder contains a list of sub-folders with Vendor's TaxID plus .incoming. For examples D:\Source\123456789.incoming
and D:\Source\111111111.incoming. Every day, files in format for text file will be submitted via vendors to their taxid.incoming folder.
I have a folder called Destionation under F:\ . Under Destination folder are subfolders with the vendor's taxid. For examples, F:\destination\123456789 or F:\destination\111111111.
I need to create an ssis package to automate copying all the vendor files to their own destination folder.
Can somebody help?
Thanks,
October 19, 2011 at 2:42 pm
What is your question, precisely?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply