developer.* Blogs - Causes for SSIS FTP Task RemotePath and LocalPath Error - Comments

Thank you so much!!!

Guest — Tue, 13 Jun 2006 11:23:59 -0700

Thank you so much!!! Creating a variable with /*.* and setting the IsRemotePathVariable works like a charm!! You've saved me lots of time in investigating (I was trying to use the Expressions RemotePath property and it didn't work).

You can download them by

Guest — Mon, 12 Jun 2006 11:44:07 -0700

You can download them by useing variable instead connection, variable can be like /folder/*.*, set isRemoteVariable in true.

FTP Neglected in General

Daniel Read — Tue, 14 Mar 2006 07:27:56 -0800

Hi Charley,

Thanks for the comments. FTP, like printing, is one of those areas that is consistently neglected by Microsoft (and other language and platform vendor's too, as evidenced by the fact that Rob MacGrogan's Java printing post is consistently one of the most popular on this site). For example, it's amazing to me that the .NET CLR does not contain FTP capabilities. (And while I'm bitching, why not some native ZIP archive support in .NET and/or SSIS?)

I think one thing that happens with FTP libraries in general, including the FTP task in SSIS, and the old one in DTS (which didn't even support uploading) is that the functionality tends to be limited to the crude, decades old FTP commands. What's needed are aggregate operations that do something more sophisticated on my behalf, like your example of looping through files based on a wildcard match.

Thanks again,
Dan

RE: FTP Path Errors

Charley Evans — Tue, 14 Mar 2006 06:58:46 -0800

Dan,

"RemotePath property requires a full path, including the filename"

This was the problem that plagued the old 2000 DTS FTP task and I was hoping that it'd be fixed with SSIS. I don't understand what's so hard about writing an object that looks for *.* or *.xml (whatever) in the ftp directory and downloads it. Let me deal with any errors it throws.

This aside, you'd think you be able to use the For Each Loop container to loop through the files with *.XXX file type in the FTP directory. You can do this for anything with a regular directory structure, but try doing it with a FTP directory and it seems that you're out of luck.

Causes for SSIS FTP Task RemotePath and LocalPath Error

Daniel Read — Sat, 28 Jan 2006 16:58:31 -0800

I have figured out two different causes for this error from the FTP task. In my direct experience I was using IsLocalPathVariable = True with an SSIS variable mapped to the LocalPath property. But after thinking about it, I imagine both of the following scenarios would be possible even if you were not using a variable (please add a comment if you can confirm this).