Hi Everyone,
I am using SQL TASK In SSIS, Below is my query that I am using...
--First SQL
Declare @CC_QA VARCHAR(20)
SET @CC_QA = ( SELECT c_code FROM client
WHERE id = ? )
SELECT @CC_QA AS CCode_QA;
--Second SQL
DECLARE @CampCode VARCHAR(20)
SET @CampCode = (SELECT cname FROM dbo.Paign)
SELECT @CampCode AS cname_QA;
--Third SQL
DECLARE @RCode VARCHAR(20)
SET @RCode = (SELECT Rcode FROM dbo.AttGroup
WHERE ID = ?
)
SELECT @RCode AS Rcode_QA;
Note: ? I am passing Parameter Mapping and @CC_QA /@CampCode /@RCode is my Result Sets Variables.
I am using RESULTSET = SingleRow.
I am getting an error, Please guide me what I am doing something wrong. Appreciated.