Forum Discussion

marenas's avatar
marenas
Contributor
5 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 - valida...
file-writer
siwadon's avatar
siwadon
Employee
5 years ago

The problem is the filename contains an illegal character :

The following characters are not allowed for SMB directory and file names: " \ / : | < > * ?

marenas's avatar
marenas
Contributor
5 years ago

the illegal character is the value of

“last-modified”: “2021-08-13T22:51:44.288 UTC”

so I removed that for now and it works!!! I guess I need to format that value to an acceptable format. thank you for your help @siwadon!!!