Execute Query activity within a If activity

[eric.brenner]

Is it not possible to use the Execute Query activity within an If activity? When I try to execute a simple SELECT statement against my SQL Server database, I receive the following error:

As a workaround, I could do a For Each activity but I am unsure of how to exit out of the activity when I have found my data (and no further need to continue scanning).

Looking forward to your suggestions.

[lakshman (Ganta lakshman)]

@eric.brenner

It seems like you passed new configuration and also existing configuration details to connect to the Database for this activity because of that you are getting this error.

Can you please share screenshot of the Execute Query activity.

[AKM_Robinuzzaman (Robin Zaman)]

Hello @eric.brenner,

I think you have not disconnected the previous database connection.

Best,
Robin

[eric.brenner]

I believe that Execute Query activity was somehow corrupted or not working properly. When I deleted and recreated it using the exact same connection and SELECT statement, it works properly.

Sorry to bother you.