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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:53 PM
Points: 1,388, Visits: 3,039
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 5,316, Visits: 12,346
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.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1420444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse