Hi There,
We are trying to create a data flow which has a XML source. The values
in the XML will be parameters to the stored procedure. The procedure
runs on its own. When I try to run the data flow with XML source it
throws an error saying "Incorrect syntax near "/". " I am not sure how
to get to the root of the error to fix it. There is no more description
where exactly the error is occurring.
Can someone help with this issue?
Enclose date and string parameters in single quotes. That should fix the issue. We will make a note to provide better error message in a future build.
exec HandleFaxConfirmation
'@DateInput',
'@TimeInput',
@FaxHistoryId,
@NoOfPages,
@Duration,
'@Filename',
@Result
I use SQL Statement Destination, no Output. The SQL fails and an error counted in the Job summary for this destination. Where to lookup the error description?
