September 21, 2015 at 12:29 pm
Hey, been trying to figure this out and haven't come up with a solution.
Been trying to FTP a file locally to our production FTP server, however it will either send an empty file or a partial file (always in 1000 byte increments). I've been able to successfully ftp to an External personal FTP server and FTP via the command prompt, but cannot get it to FTP successfully via SSIS. The SSIS package has only one step, a simple FTP task.
Using Sql 2008 R2. The file is only 3.5kb, and it only ftps over in o, 1kb, 2k, or 3kb (rarely the whole thing). the file size changes each time i run the package
September 22, 2015 at 7:43 am
Hi Chris
Did you try to change the chunk size in FTP Connection property?
Br.
Mike
September 22, 2015 at 7:50 am
I did. I tried changing it to 1000kb and still nothing.
My first attempt got over ~1367 bytes of information (which i found strange) but every run afterwards would receive a 0byte file.
September 30, 2015 at 7:55 am
I've even now tried to trace it via wireshark now, and i didn't see anything that stood out. Still getting this issue
September 30, 2015 at 8:21 am
Hi
I've got some projects where files are uploaded on sftp(ftp) servers, In most cases I prefer
send file by Execute Process Task and wget software.
Additionally I set logging to trace the upload.
Br.
Mike
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply