Link to home
Start Free TrialLog in
Avatar of Roxanne25
Roxanne25

asked on

SSIS - FTP Task Help?

Hello ...again. :)

Hopefully this question will be easier than some of the others I have asked.  In SQL 2000 we were using an extended stored procedure to ftp files... in sql 2005...this process is no longer working.  As I learned about the ftp task in SSIS I thought this would be a much easier way to get the job done than trying to troubleshoot this complex extended stored proc.

My experience with SSIS has been mostly reporting services projects... so, I'm a wiz at making reports but totally lost on making SSIS packages.

I'm trying to figure out what to drop from the toolbox and how to do the flows for this...

I just want to take a text file that is sitting on the server and ftp it to another server...Nothing fancy or special...

Right now I have a file system task, the ftp task and a connection manager for the flat file.  But my little tasks have x's on them...

Anybody have an example packge they could upload or instructions that could walk me through how to set this up?

Thanks a bunch!
ASKER CERTIFIED SOLUTION
Avatar of carsRST
carsRST
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Roxanne25
Roxanne25

ASKER

Ok, so do I need any other objects then?  Is the only thing I should have in the package window the ftp task?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
oh neato that's so simple.. :P

What about success/failure is there any kind of logging or notification if the ftp was successful?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ok thanks...

I just tried it...and I'm still getting some errors...

I added the ftp task
I set up the connection manager to the ftp server and tested the connection
I selected the file on the local server that I want to send

The problem I'm having is with the remote path?  I'm not sure how to set that... I put in /ftp as the path and I ran it then I got this error:

[Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Type set to I. 200 PORT command successful. 550 /ftp/CCRPreprocess_SMALL.TXT: The system cannot find the path specified.  .

the text file its listing is the one I'm trying to send... so I'm not sure why it says it cannot find the path specified...cause of course it wouldn't be there... I'm trying to put it there! :)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hmm when I did that it didn't show me anything :/
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oh I get it!  

WOOT IT WORKED!

PRAISE THE LORD!

TY TY.