n_srikanth4
asked on
load the latest file from FTP to Target table.
Hi,
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
http://www.rad.pasfu.com/index.php?/archives/30-Find-Last-Created-File-in-Special-Directory-SSIS.html
Step 2
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
ContactDetailsApril6.csv
ContactDetailsApril7.csv
ContactDetailsApril8.csv
ContactDetailsApril9.csv
ContactDetailsApril10.csv
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.
Regards,
Sreekanth.
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
http://www.rad.pasfu.com/index.php?/archives/30-Find-Last-Created-File-in-Special-Directory-SSIS.html
Step 2
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
ContactDetailsApril6.csv
ContactDetailsApril7.csv
ContactDetailsApril8.csv
ContactDetailsApril9.csv
ContactDetailsApril10.csv
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.
Regards,
Sreekanth.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and for load in table use dataflow task in which use flate file source and destination as a oldb destination which is to your sql table.
Regards,
nishant