November 6, 2009 at 5:25 pm
Hi All...
I thought I was an SSIS expert but I don't feel like one now...
I need to do a standard FTP upload of file(s) via SSIS...I would think this has been done a bazillion times through SSIS...
First I added the variables necessary...
Variable vDPKFilePath_FTP to "/dpk_import/" (backward slash for FTP)
Variable vDPKFilePath to "C:\Dpk_Import\Files"
I added an FTP connection and connected to my remote ftp server...
ntbu.bydeluxe.com
I tested connection and it works fine...
The files live at ntbu.bydeluxe.com/dpk_import
Then I added an FTP task to use this connection...
Under file transfer tab...
Remote Parameters:
IsRemotePathVariable True
RemoteVariable User::vDPKFilePath_FTP
Local Parameters
IsLocalPathVariable True
LocalVariable User::vDPKFilePath -> Contains C:\Dpk_Import\Files
OverwriteFileAtDest True
Operation
Operation Receive Files
Ascii False
No expressions used...
The FTP does not give the red X with a circle...Builds fine...
When I execute task, it just goes yellow and does not do anything...
I know this should be simple but I'm just not getting it...
Could someone point me to an example that a 1st grader (cause that's what I feel like) could follow...
Thanks a million in advance...
Howard
November 6, 2009 at 5:47 pm
I finally figured out...The ftp server had some kinda port setting that I'm not sure how to describe...But...
I had to set the passive flag on the connection and it works like a charm...
Thanks in advance...Hope this saves someone some time...
Howard
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply