Topic "What does TransferMode=2 mean in the WinSCP.ini file mean?"

Author Message
mostokes
[View user's profile]

Joined: 2010-10-13
Posts: 4
We are using the WinSCP.exe to execute FTP file transfers between two Windows servers. The WinSCP.ini file has a setting in it called TransferMode=2. What does that setting mean?

Our original problem is, after the file is FTPd from server one to server 2, line breaks are being inserted in the middle of data records, which causes problems when we try to import the file into SQL Server via a DTSX package.
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
It means "Automatic" (mask-based) mode.
mostokes
[View user's profile]

Joined: 2010-10-13
Posts: 4
prikryl wrote:
It means "Automatic" (mask-based) mode.


Thanks prikryl. Have you ever heard of files becoming corrupted during the FTP process? The file I'm transferring is almost 11 mb in size. Prior the being FTPd the file is ok. After the file reaches the destination server, it includes line breaks where there shouldn't be line breaks (in between records, etc.). Thanks for any help you can provide.
mostokes
[View user's profile]

Joined: 2010-10-13
Posts: 4
prikryl wrote:
It means "Automatic" (mask-based) mode.


One thing I forgot to mention. I am doing an automated FTP transfer, by executing WinSCP.exe using a scheduled task on the SQL Server. The WinSCP file is configured (see below) to import 2 text files. The second file (CareTechDonorProfile.txt) is what we're having trouble with. Is there a way to force binary in the WinSCP.ini file settings. I read that someone else solved a crlf problem by forcing a binary file transfer. But they did it through the GUI interface. Thanks.

option batch on
option confirm off
open sftp://xxxxxxxx:#####@sftp.######.org -hostkey="ssh-dss 1024 xx:xx..."
get /CareTechDonorGiftView.txt c:\import\
get /CareTechDonorProfile.txt c:\import\
exit
mostokes
[View user's profile]

Joined: 2010-10-13
Posts: 4
prikryl wrote:
It means "Automatic" (mask-based) mode.


YOU CAN DISREGARD MY RESPONSES TO YOUR ANSWER...

I found this forum post, which resolved my issue. https://winscp.net/forum/viewtopic.php?t=4540
When I changed the WinSCP.ini setting to TransferMode=0 and re-FTPd the file, everthing worked just fine. Thanks for your help.
Satya

Guest


prikryl wrote:
It means "Automatic" (mask-based) mode.


what is the TransferMode value for Binary?
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
Satya wrote:
what is the TransferMode value for Binary?

0 (zero). What do you need this for?
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License