Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

remote path is not the default path on ftp Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 2:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 8:35 AM
Points: 27, Visits: 67
i created a package following this http://stackoverflow.com/questions/140850/how-to-avoid-ssis-ftp-task-from-failing-when-there-are-no-files-to-download

it's working except that the ftp task will not go to the specified remote path, and i think it's because the remote path is not the default path.
when i connect with a filezilla, the default directory is another path.

someone got a brilliant idea to help me?

thanks.
Post #1416900
Posted Thursday, February 14, 2013 2:58 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 6:26 AM
Points: 1,521, Visits: 3,036
Hello, and welcome to SSC.

I'm afraid there are way too many unknowns behind your question for anyone to competently answer.

Please review the tips on how to effectively ask for help here in this posting: http://www.sqlservercentral.com/articles/Best+Practices/61537/



Post #1420315
Posted Friday, February 15, 2013 2:25 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 4,976, Visits: 11,666
l.caufriez (2/7/2013)
i created a package following this http://stackoverflow.com/questions/140850/how-to-avoid-ssis-ftp-task-from-failing-when-there-are-no-files-to-download

it's working except that the ftp task will not go to the specified remote path, and i think it's because the remote path is not the default path.
when i connect with a filezilla, the default directory is another path.

someone got a brilliant idea to help me?

thanks.


Did you try the suggested 'Script Task' solution? The 'RemotePath' property would seem to give you what you want.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1420444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse