Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS FTP task transfer mode?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-06 : 00:22:37
Kalle writes "Hi!

I have been trying out the FTP task in SQL 2000 DTS. It seems the transfer mode is automatically set to binary when connecting to the FTP server, regardless of the default setting on that server. I would like to change the transfer mode to ascii, but I have found no method or property allowing me to do that.

Is it possible or do I have to go back to .bat files and FTP scripts?

I'm running Windows 2000 advanced server with service pack 1 and SQL server 2000 with service pack 1 (build 2195).

Thanks in advance,
Kalle Dahlberg"
   

- Advertisement -