FTP File Exists Task

Title: *

Script File

Changes made to the attachments are not permanent until you save this post.

	Delete		Description	Size
			http://www.cozyroc.com/sites/default/files/script/FtpFileExistsTask.stx	16.16 KB

If a new file is uploaded, this file will be replaced upon submitting this form.

Attach new file:

Select SSIS script to upload.
Allowed extensions: stx scx

Body: *

h2. Overview

Script task to verify for existence of remote FTP file.  It has the following parameters:
* *FtpConnection* - secure FTP connection manager selection (SFTP, FTPS).
* *RemoteFile* - path of remote file to check.
* *CheckLocal* - if true, check additional remote file attributes against a local file.
* *LocalFile* - path of local file to compare against.
* *CheckSize* - if true, include verification of remote file size against local file size.
* *CheckTime* - if true, include verification of remote file modification time against local file modification time.

If the verification process is successful, the task result is success. Otherwise it is to set failure and you can take further appropriate actions in your SSIS workflow.

h2. Requirements

Depends on CozyRoc "Script Task Plus":/ssis/script-task component for implementing parameters user interface.
Depends on CozyRoc "SSH Connection Manager":/ssis/ssh-connection or "FTPS Connection Manager":/ssis/ftps-connection for securely accessing remote FTP server.
Requires installation of CozyRoc SSIS+ 1.3 library.

E-Mail addresses are hidden with reCAPTCHA Mailhide.
You can use Textile markup to format text.
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.

More information about formatting options

Log message:

An explanation of the additions or updates being made to help other authors understand your motivations.

CAPTCHA

This question is for testing whether you are a human visitor and to prevent automated spam submissions.

PASS Summit '10

November 8 - 11, 2010 Washington State Convention & Trade Center in Seattle, WA

CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Register with code CR3D and get $100 off.

CozyRoc SSIS+ has been nominated for the 2010 SQL Server Magazine Community Choice Awards, category "Best Business Intelligence & Reporting Product". Vote Now to help us win this prestigious award.