tFTPPut-Component is cutting my CSV-File

Highlighted
Five Stars

tFTPPut-Component is cutting my CSV-File

Hello Talend-Community,

 

i have a problem with the tFTPPut-Component.
I use it to transfer one CSV-File (38kb) to an SFTP-Server. The transfer works well, the file is landing in the right directory but for any reason it is not complete, somehow the middle of the CSV, the data are missing.
Before i send the file i saved it in my local Directory, here is everything fine, but when i send via tFTPPut the data gets lost.
Do you have any Ideas?

Thanks for your help!

 

ETL-Talend-Version: 6.3.1
In the screenshot you can see my configuration for my tFTPPut-Component.

 

Greetings

Magerquark.


Accepted Solutions
Five Stars

Re: tFTPPut-Component is cutting my CSV-File

I found the Problem.
The mistake were made between the tFileOutputDelimited-Component and the tFTPPut-Component. I used a Row>Main instead of an Trigger> On Component Ok
I can imagine that the tFTPPut-Component tried to send the file which was still in the makeing.
Not it works fine.

View solution in original post


All Replies
Ten Stars

Re: tFTPPut-Component is cutting my CSV-File

IS the file still open for read or by another process? does it happen with a different file too? if so...
You need to solve this with your network admin, because it could be some overflow / flowcontrol thingy on router/gateway level, looks like packet loss.
Five Stars

Re: tFTPPut-Component is cutting my CSV-File

I found the Problem.
The mistake were made between the tFileOutputDelimited-Component and the tFTPPut-Component. I used a Row>Main instead of an Trigger> On Component Ok
I can imagine that the tFTPPut-Component tried to send the file which was still in the makeing.
Not it works fine.

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog