Going Crazy with FTP Task!

#1

Hi guys...

When I execute a FTP Task, the text file which I am trying to copy from an internet site is placed in the destination folder. The problem is that the file is actually being changed by the task when it is copied

The original text file ends each row properly with the newline character (\n), and the new file no longer has this value! The text just keeps wrapping around

The end result is that the orignal file can successfully be used in a BULK INSERT, but the newly transfered file can not

Any suggestions in dealing with this problem

Thanks

Forch

#2

Ok..... I found the problem. The DTS FTP Task uses Binary Mode, and not ASCII Mode. This there a way to transfer in ASCII Mode

Thanks

Mar

#3

The property isn't exposed with the FTP task. You can set
the mode and have a bit more control by using the command
line ftp.exe with an Execute Process task.

-Sue

On Tue, 11 Nov 2003 09:41:25 -0800, "Forch"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Ok..... I found the problem. The DTS FTP Task uses Binary Mode, and not ASCII Mode. This there a way to transfer in ASCII Mode?

Thanks,

Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Going Crazy with FTP Task!

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Going Crazy with FTP Task! - 11-11-2003 , 10:21 AM

RE: Going Crazy with FTP Task! - 11-11-2003 , 11:41 AM

Re: Going Crazy with FTP Task! - 11-11-2003 , 01:23 PM