Requirement : Need to copy the latest CSV file from FTP Shared drive to my local machine and then need to load it to the Target Table(SQL SERVER 2008) using the SSIS 2008.
Step 1: Will get the latest file from the FTP Drive using the Script task as mentioned below
After getting the latest file (with time stamp) , I am unsure how to copy it to the folder in my local machine and then rename the file to a Specified Name("ContactDetails") as mentioned in the Flat file Connection Manager ?
Example: Files in the FTP Shared Drive
Here ContactDetailsApril10.csv is the latest file
Could you please help me with the solution in detail and also please suggest that solution mentioned in Step 1 works fine.