May 17, 2004 at 9:56 am
I have set up a local package with an ftp task which aims to transfer a file from an AS400 to a 'SQL Server' server, scheduled on a daily basis. I can't see settings which refer to the TransferType, and assume it defaults to binary, whereas I require an ASCII transfer? Is there any way around this?
Georgina
May 18, 2004 at 7:17 am
You are correct, I don't see anyway to specify ASCII or BINARY in DTS.
I have two simple DTS packages, each containing a single FTP task. One task transfers a self-extracting archive (.exe), the other a .SQL script, which is text. Both transfer without a problem.
Is your problem that fact that the AS/400 uses EBCDIC and not ASCII? I'm not sure, but I don't think the ASCII option in FTP automatically converts EBCDIC to ASCII.
Mike
May 18, 2004 at 7:51 am
Yes the file is EBCDIC. When I tried the file through an ASCII transfer in Reflection it looked OK. I will try an ftp command line in the DTS.
Thanks
Georgina
May 18, 2004 at 2:07 pm
Not sure if this helps, but I have something similar. Weekly I have run a dts package that I FTP to another site. I have it run as a scheduled job with step 1 being the DTS package that puts all my information into a local DB. Step 2 is a DB backup of the DB updated with the DTS package. Step 3 is an FTP command line call to send the file. The FTP is run by a command shell call like this:
ftp -s:C:\FTPCOMMANDFILE.ftp
With the contents of the command file formatted like this in my case.
Ftp
Open xxx.xxx.xxx.xxx
<username>
<password>
bin
put
c:\someFile.dat
bye
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply