none
create SSIS package to import data file content into sql server tables

    Question

  • I have a large number of data files and would like to import the content into sql server 2008 table. I have already tested a sample file to make sure the fields can be imported but I need to create a package that imports these files on a schedule. I have the FTP connection manager created but not sure how to start the control flow. Does anyone have a link to a tutorial or steps to do this? Appreciate it.
    Tuesday, November 20, 2012 6:12 PM

Answers

  • I found exactly what you need http://tayloredbi.wordpress.com/2012/04/30/ssis-download-ftp-files-loop-through-files-and-insert-into-database/


    Arthur My Blog

    Tuesday, November 20, 2012 6:15 PM
  • Since the FTP Task is limited to shuttling files over the network only, you will have to deposit (sit) the file on disk before uploading it to a database table. I suggest you do not place the files to a share, but a local drive.

    Arthur My Blog

    • Marked as answer by Eileen Zhao Tuesday, November 27, 2012 1:45 AM
    Wednesday, November 21, 2012 7:11 PM

All replies

  • I found exactly what you need http://tayloredbi.wordpress.com/2012/04/30/ssis-download-ftp-files-loop-through-files-and-insert-into-database/


    Arthur My Blog

    Tuesday, November 20, 2012 6:15 PM
  • Thanks for your  response. One quick question; can I import the file directly into the sql server table or does it have to be downloaded to a local drive location first?

    Tuesday, November 20, 2012 6:30 PM
  • Since the FTP Task is limited to shuttling files over the network only, you will have to deposit (sit) the file on disk before uploading it to a database table. I suggest you do not place the files to a share, but a local drive.

    Arthur My Blog

    • Marked as answer by Eileen Zhao Tuesday, November 27, 2012 1:45 AM
    Wednesday, November 21, 2012 7:11 PM