|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 2:12 AM
Points: 14,
Visits: 49
|
|
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.
|
|
|
|
|
UDP Broadcaster
      
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:57 PM
Points: 1,491,
Visits: 3,008
|
|
|
|
|
|
SSCarpal Tunnel
       
Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 4,227,
Visits: 9,460
|
|
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:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.
|
|
|
|