Does anyone have any experience with moving attachments from SQL Server to Domino/Notes using lotusscript? Running into an issue where some files are corrupted (word and rtf documents). Using lotusscript connectors, V11. Appears to be dropping data at the end. Most files are migrating without issues, but some are corrupt.
Wich is the procedure that you use to migrate those files from SQL to domino? You first download the files to a temporary folder, and then upload it to a Notes document using something like
Set object = rtitem.EmbedObject( EMBED_ATTACHMENT, "", "c:\temp\tempattachment.txt")
If you first download the attachments to a temporary folder, try to validate if the corrupt attachments are also corrupted on disk, once downloaded, if so the problem is in the temporary download (or perhaps they are also corrupted in the SQL server). I don't think uploading them to Notes will corrupt them.
Could you share a piece of code?
Attached is sample code. The files are not corrupt when downloaded from the UI we are migrating away from to Domino. We think the corruption issue occurs because of the libraries I'm using. If the files have an odd length, the file becomes corrupt.
After I posted the question, I've created an app in visual studio that can download the files without corruption from SQL server and then added connections to Domino to upload the files. This appears to be working with the problem children I have identified thus far. So I'm able to move the files with this method.
Now trying to gain a better understanding of why and is it possible to address the issue within lotusscript.
DocAttchScript.txt