Post reply

WORKING FTP TASK IN SSIS SQL SERVER 2005

  • July 2, 2010 at 1:21 am

    #145757

    Hey

    i need to work the ftp task in ssis in sqlserver.but i dont know.can any one help me...how to work with this.the mail aim of my project is

    Sends a file from the my computer to the FTP server Directory.

    Creates a folder on the FTP server.

    Saves a file from the FTP server to the local computer

    can any help me step by step

  • July 2, 2010 at 7:35 am

    #1188206

    I have not done much of FTP but did in one project like this to FTP files:

    Step 1:

    create a BATCH file saying:

    ftp -s:D:\mypath\Myfile.txt

    Step 2:

    Created a .txt file specified in this path( Myfile.txt) to do actual FTP like this :

    open SRC_SERVERNAME

    USERID

    PASSWORD

    Get 'SRC_FILE1(0)' "D:\<path>\File1_Extract.txt"

    Get 'SRC_FILE2(0)' "D:\<path>\File2_Extract.txt"

    Get 'SRC_FILE3(0)' "D:\<path>\File3_Extract.txt"

    quit

    Here the SRC FILES are the files that I want to bring from the source and the names File*_Extract.txt are the names that I give to those files on my system...

    I will run the batch file only Myfile.txt, and then it will run the otherfile statement and files should be in the path that I gave...

    Hope this helps...

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

Viewing 2 posts - 1 through 1 (of 1 total)

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