Unable to Write data to an excel destination

[nimra.arshad]

Hi,
I was writing a dataset from the Northwind database using the Database Table source to an excel destination. However, When I run the dataflow, it ends up in error. I have attached the error message and the screenshot displaying the dataflow here.

Message : Type BlobKey is not supported.

Product Version: 9.0.0.219
OS Info: Microsoft Windows NT 6.2.9200.0

Exception Class Name: Astera.Transfer.WriterException

Stacktrace: at Astera.Transfer.ExcelWriter.Write(RecordObject record)
at Astera.Transfer.BaseWriter.Process(RecordObject record)
at Astera.Transfer.DataflowChainItem.ProcessMappedRecord(RecordObject destinationRecord, IDataflowTask task)
at Astera.Transfer.DataflowChainItem.OnProcess(IDataflowTask task, IScopedProcessContext rtc)

Message : Type BlobKey is not supported.

Product Version: 9.0.0.219
OS Info: Microsoft Windows NT 6.2.9200.0

Exception Class Name: System.NotSupportedException

Stacktrace: at GemBox.Spreadsheet.ExcelFile.ThrowExceptionForUnsupportedType(Object value)
at GemBox.Spreadsheet.ExcelCell.set_Value(Object value)
at Astera.Transfer.ExcelWriter.SetValue(ExcelWorksheet worksheet, Int32 row, Int32 column, Object value)
at Astera.Transfer.ExcelWriter.Write(RecordObject record)

[abdul.rehman]

Hi Nimra,

In the Employee table in the Northwind database, the ‘Photo’ field is an image type that Excel does not support. In order to write employees’ data into excel, you need to remove the ‘Photo’ field from the layout builder screen of Excel Destination.

[nimra.arshad]

It is working. Thanks!