Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
create SSIS package to import data file content into sql server tables

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

  • Tuesday, November 20, 2012 6:12 PM
     
     
    Sign In to Vote
    0
    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.
     

All Replies

  • Tuesday, November 20, 2012 6:15 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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:30 PM
     
     
    Sign In to Vote
    0

    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?

     
  • Wednesday, November 21, 2012 7:11 PM
    Moderator
     
     Answered
    Sign In to Vote
    0
    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