Error in logs with using exec in the select statement box for MSSQL Data Reader

More
8 years 11 months ago - 8 years 11 months ago #11743 by daniel.fung@xerox.com
Information 10/27/2014 5:08:22 PM Reader:{A} Connection Type is: MS Sql Server
Information 10/27/2014 5:08:22 PM Reader:{A} Source Select Statement: exec tsp_GetDataTest
Error 10/27/2014 5:08:22 PM SQLExecDirect(FHSMT,PChar ('select count(*) as rec_count from (exec tsp_GetDataTest) a'), SQL_NTS) Failed: 42000 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'exec'.
Warning 10/27/2014 5:08:22 PM Reader:{A} Unable to determine number of records in the Data Source:
Information 10/27/2014 5:08:22 PM Using Bulk Fetch
Attachments:
Last edit: 8 years 11 months ago by daniel.fung@xerox.com.

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #11744 by Peter.Jonson
Daniel

This is expected behaviour.
Software is trying to get number of records in the source,
If it is unable to do so you get this message.
You can just ignore it

Mike

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.