If anyone is still watching this, the problem is that there is a return value from the SQL query that doesn't have an assigned column name.
BAD:
SELECT
BCode
,SUM(Waa)
FROM
table1
GOOD:
SELECT
BCode
,SUM(Waa) AS Waa_Sum
FROM
table1
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I'm using the new script activity to perform two select queries in my database. I have set the dynamic content to be like this:
@concat('SELECT BCode, SUM(Waa) FROM table1 WHERE BCode=3 AND Date=''', variables('currentDate'), ''' GROUP BY BCode ',
'SELECT BCode, SUM(Waa) FROM table1 WHERE BCode=3 AND Date=''', variables('previousDate'), ''' GROUP BY BCode')
However, when debugging the pipeline all I get is the following error:
Error code
2011
Failure type
User configuration issue
Details
Argument {0} is null or empty.
Parameter name: paraKey
However, I have other script activities before this one and none of them is failing. What is wrong?
Thanks in advance.
If anyone is still watching this, the problem is that there is a return value from the SQL query that doesn't have an assigned column name.
BAD:
SELECT
BCode
,SUM(Waa)
FROM
table1
GOOD:
SELECT
BCode
,SUM(Waa) AS Waa_Sum
FROM
table1
Hi @KranthiPakala-MSFT ,
I do not have paraKey
anywhere in my script. I actually changed to another query, different than the ones I posted above, and my error was gone. I will be marking this as solved, but something in my previous queries wasn't right.
Thanks for your help.