Error - "Element already read to the end " - winscpnet.dll
Hi,
First of all, congratulations for your wonderful work with WinSCP!
I use winscpnet.dll in a SQL Server Integration Service package, in a Dataflow task, specifically in a Script Component (transformation component).
The protocol is FTP.
The DataFlow task downloads a variable number of files using this Script component (code similar with what you have for SSIS in samples).
The session is created/opened in PreExecute() and closed in PostExecute() methods of script component.
Multiple instances of the package can run simultaneously, downloading different files from the FTP server at the same time.
On production server we receive "Element already read to the end" errors from time to time. We have to retry the download for the files affected in a later package schedule run.
Maybe you have an idea what is the cause of these errors and how I can avoid these?
Thank you!
Regards,
Adrian
First of all, congratulations for your wonderful work with WinSCP!
I use winscpnet.dll in a SQL Server Integration Service package, in a Dataflow task, specifically in a Script Component (transformation component).
The protocol is FTP.
The DataFlow task downloads a variable number of files using this Script component (code similar with what you have for SSIS in samples).
The session is created/opened in PreExecute() and closed in PostExecute() methods of script component.
Multiple instances of the package can run simultaneously, downloading different files from the FTP server at the same time.
On production server we receive "Element already read to the end" errors from time to time. We have to retry the download for the files affected in a later package schedule run.
Maybe you have an idea what is the cause of these errors and how I can avoid these?
Thank you!
Regards,
Adrian