Forum Discussion

marenas's avatar
marenas
Contributor
4 years ago

Reading BLOB data from SQL and write it to file share

Dear Community,

I am successful in creating a pipeline that read blob data from SQL server and writing the file in SLDB. Now, I wanted to write the file on an SFTP server using File Writer - validation is okay but failed during execution.

protocol: smb
file name, = enable: targetDir + ‘/’ + $ID+ '’ + $[‘last-modified’] + ‘.jpg’
write empty file: check

error: Failed to open output stream for … Reason:
Unable to create/open

Thanks in advance for the help.

4 Replies