Post reply

How to get flat files from FTP location onto SQL Server

  • July 30, 2010 at 7:48 am

    #235868

    Can anyone please let me know how i can automate the process of getting the flat files from FTP location (MainFrame) onto SQL Server Windows machine and load it into sqlserver tables? Currently i am doing it manually by drag and drop method but i would like to automate this process. There will be some 15-20 files in the FTP location and the files will be updated everyday. The file names are same everytime and in the same location

    Any help on this is really appreciated.

    Thanks for your Help!!!

  • July 30, 2010 at 9:02 am

    #1200417

    You may use xp_cmdshell to execute the command line parameters for the FTP command. Also you may try using SSIS

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • July 30, 2010 at 10:09 am

    #1200459

    Currently i am doing it manually by drag and drop method

    Sounds like you already have a load method and you just need to get the files, I would use SSIS FTP task to pull each file in turn and drop into your load folder.If the source is secure FTP then the in box FTP component will not work but there are scripts available or use Cozy Roc SFTP component (it's good)

  • July 30, 2010 at 11:21 am

    #1200482

    I havent used FTP Task till now. Can you please let me know how i can do this with the FTP Task?

  • July 30, 2010 at 11:50 am

    #1200488

    Have you used SSIS?

  • July 30, 2010 at 12:25 pm

    #1200501

    Yes but not much. I worked most on DTS. I didnt use FTP task till now in SSIS. If you can brief me how to use FTP TASK for my automated process that would be great.

  • July 30, 2010 at 1:00 pm

    #1200514

    Try this article

    http://msdn.microsoft.com/en-us/library/ms137656.aspx

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply