I am loading 5 different csv files into sqlserver db (into one table) by using 5 data flow tasks (each data flow for each csv), I am doing this monthly once manually.
Would you please explain me how I need to automate this process.
Another thing is, how we can load csv file into sharepoint URL by using SSIS.
Its a kind of urgent...........
Advanced Thanks