Run query: Value cannot be null. Parameter name: Value for required activity argument 'ProviderName' was not supplied

alexis.mendoza · September 28, 2023, 7:33pm

I have the following case.

I am trying to execute a query in a database, but I get the following error

postwick · September 28, 2023, 7:35pm

It looks like you have line breaks in your SQL query ie…

SELECT *
FROM sometable
WHERE somevalue = ''

Don’t do that. Put it all on one line.

neha.upase · September 28, 2023, 7:45pm

Hi,

Can you please share the screenshot of properties of run query activity

system · October 1, 2023, 7:45pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Execute query: value cannot be null error Activities database , question	1	240	August 3, 2023
None of the overload groups have all their required/optional activity arguments configured. Stored Procedure Activities database , activities , question	3	156	December 16, 2023
How to resolve the Error: System.ArgumentNullException: Value cannot be null. Parameter Name: providerInvariantName while using Database Activity Knowledge Base studio	0	3358	April 15, 2021
Value cannot be null -Parameter atleast one of the connections must be used Activities excel , activities	30	1192	June 22, 2023
Run query not working when I am passing connection string and sql in argument Studio studio , question , activities_panel	8	392	May 11, 2023