SQLTeam.com | Weblogs | Forums

SQL Task in SSIS Help


#1

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.


#2

you said "Single Row" but you are returning 3 rows. No wonder you're getting errors. Btw when you ask about an error, post the error message, please.


#3

Please share the ERROR MSG that you are facing during this, please don't be lazy in writing if you need an assistance.