- Posts: 189
- Thank you received: 9
Error in logs with using exec in the select statement box for MSSQL Data Reader
- daniel.fung@xerox.com
- Topic Author
- Offline
- Elite Member
-
Less
More
8 years 11 months ago - 8 years 11 months ago #11743
by daniel.fung@xerox.com
Error in logs with using exec in the select statement box for MSSQL Data Reader was created 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
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
Last edit: 8 years 11 months ago by daniel.fung@xerox.com.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 11 months ago #11744
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Error in logs with using exec in the select statement box for MSSQL Data Reader
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
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.