Read dynimc csv file from FTP and insert into sql DB

• kd.nithin

  SSC Enthusiast

  Points: 113

  More actions

  March 1, 2012 at 3:15 am

  #252369

  hi

  i am very new to ssis concept.

  i would like to know how can i read an csv file from FTP. it is dynamic one,Its name depends upon current date.so i need to read based on date and insert into corresponding sql table.i would like to run this task each day.so i need a scheduler also.how can i achieve this using ssis??

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  March 5, 2012 at 5:13 am

  #1454737

  1. FTP the .CSV file to a local directory.

  2. Create a dynamic connectionstring to the flat file:

  SSIS - Dynamically set Flat File Connection Manager

  3. Read the flat file and write the data to SQL Server.

  4. Schedule your package using SQL Server Agent.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP