This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi [bojanvelevski],thanks, you are right, I disabled the snaps after the error pipeline (PE3) and the SQL Execute runs no problem; so there must be something wrong with the snaps further down the stream, I can investigate those.
Thanks very much.
Hi Smudassir, thank you for responding,
Yes, the query is fine, it only pulls a few hundred records from a simple table. Even when I select top 1 * it still has the same issue.
The code in the SQL server - Execute 3 snap is :
Hi,
Did you ever get a solution for this, I am running into a similar issue where a SQL Execute snap that is using a SQL select top 300 * from tbl statement rather than a stored procedure;it just hangs at 1024 documents. In the SQL Server activity (...