Hi All,
In SSIS or SQL-stored procedure, I need to load multiple files to multiple folders with respect to file names
I have a scenario
Source folder = “Data Source Folder”
Files in source folders
Customer_datafile_data.csv
Customer_Branch_data.csv
Customer_City_data.csv
Employee_datafile_Dec2020.csv
Employee_Info_Dec2020.csv
Products_Information.csv
Destination Folders =
Customer
Employee
Products
Files destination as
“Customer_datafile.csv” LOADS IN “ Customer”
"Customer_Branch_data.csv" LOADS IN “ Customer”
"Customer_City_data.csv” LOADS IN “ Customer”
“Employee_datafile_Dec2020.csv” LOADS IN “Employee”
Employee_Info_Dec2020.csv ” LOADS IN “Employee”
“Products_Information.csv” LOADS IN “Products”
No. of files for one destination could be as many. No. of folders may be as many (not 3 it could be 4 or 5 )
One thing that I can control is the prefix of file is matched with folder name in which it has to load
Please help me in some good solution. Thanks
In SSIS or SQL-stored procedure, I need to load multiple files to multiple folders with respect to file names
I have a scenario
Source folder = “Data Source Folder”
Files in source folders
Customer_datafile_data.csv
Customer_Branch_data.csv
Customer_City_data.csv
Employee_datafile_Dec2020.csv
Employee_Info_Dec2020.csv
Products_Information.csv
Destination Folders =
Customer
Employee
Products
Files destination as
“Customer_datafile.csv” LOADS IN “ Customer”
"Customer_Branch_data.csv" LOADS IN “ Customer”
"Customer_City_data.csv” LOADS IN “ Customer”
“Employee_datafile_Dec2020.csv” LOADS IN “Employee”
Employee_Info_Dec2020.csv ” LOADS IN “Employee”
“Products_Information.csv” LOADS IN “Products”
No. of files for one destination could be as many. No. of folders may be as many (not 3 it could be 4 or 5 )
One thing that I can control is the prefix of file is matched with folder name in which it has to load
Please help me in some good solution. Thanks