Does anyone know how you can achieve the following.
In a importdirectory there are several CSV files.
Eacht CSV file has it;s own name based on the supplier of the file.
Now i want to add a ID of the supplier to the imported record based on the name of the file where the record was comming from.
Does anyone know how that can be accomplished in SSIS ?
View Complete Post