Post reply

Email File from FTP Site

  • December 11, 2008 at 3:22 am

    #128353

    Can I create an SSIS package to:

    Log into an FTP site and email a file. (No copy or collect)

    example:

    FTP SITE: 10.10.10.10

    Username: FTPUser

    Password: Test

    File name: TestFile

    email address: test.user@testcomp.co.uk

    Or would it be better to use a batch file?

  • December 12, 2008 at 1:16 am

    #911501

    Anyone got any suggestions.... Im stuck in which way to go!

    Thanks

  • December 12, 2008 at 10:03 am

    #911755

    Your description of the requirement is not very clear. Are you trying to FTP a file and then if successful send email?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 14, 2008 at 11:19 pm

    #912305

    Hi

    Have you had a look at the "FTP Task" and "Send Email Task" in the SSIS Control Flow?

  • December 15, 2008 at 12:41 am

    #912322

    Hi,

    Thanks for the suggestion.

    Im try to (in the following order):

    1 - Access an FTP server

    2 - Copy a file to a new directory on the FTP server

    3 - Email the file

    Not sure if this can be done using "FTP Task".

    Would I have to use "File System Task" too?

  • December 15, 2008 at 5:49 am

    #912390

    The FTP can be accomplished with FTP Task. However the emailing have to be done with script task. You have to use SmtpClient and MailMessage.Attachments property in particular. Check this script for ideas how to setup SmtpClient.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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