I have a ssis package that I have created that basically moves data from a csv to a staging table then to a production table. I want to automate the process.
The file is downloaded to a directory
the file name is : GCPeclass_Course Report_2015_Semester_2014-10-12.csv and it is located \\ms01\courseinfo
the file name changes depending on the date. ex.
when I get this file I want to
copy the file
Move the original file to a folder called archive -\\ms01\courseinfo\archive
rename GCPeclass_Course Report_2015_Semester_2014-10-12 - Copy.csv
to GCPeclass_Course Report