We have defined and File-Action for Data-Exports and followed Parameters.
Source Type: SQL Query
Source Query: An SQL-SP was returns columns and rows with Data as Strings
Destination Type: Outgoing Response
Destination: Our needed Output File-Name
File-Operation: Semicolon Delimited (SQL Source Only)
We receive always the followed Error and at the End of the Error Line always stands undefined!!???!
System.InvalidCastException: Unable to cast object of type 'System.String' to type 'System.Byte'
File Source SQL: : EXEC SSR_EXTENSIONS.dbo.smo_prod_display_data_errors_v_0_2Undefined
Table - Rows: 44 Columns: 4
Fatal Source Failure: System.InvalidCastException: Unable to cast object of type 'System.String' to type 'System.Byte'. at r2i.OWS.Actions.FileAction.BuildSourceStreams(Runtime& Caller, DataSet& sharedds, MessageActionItem act, Debugger& Debugger)
0 source(s) were identified
- DATE System.String
- VERWID System.String
- ERROR_CATEGORY System.String
- ERROR_DESCRIPTION System.String
Can anyone tell us what we made wrong.
Best Regards and Thanks