Query: Execute SQL Task

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Please will you post the two queries if you can, as well as a description of what input/output parameters and global variables you are using.

Thanks

John

Kapil S Grasshopper Points: 10 More actions · Answer 2

proc1:

id int , name nchar out

select name from xyz where id = @id

end proc1.

1st query:

(in exe sql task editor - in sql-stmt calling proc1 as

proc1 and parameters specified in the parameter mapping using @)

call to proc1.

2nd query:

insert into pqr (name1) values (@name)

@name is output derived from query 1.

On running the package the mentioned 2 errors appear

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

What Connection Type are you using? Have a look at this and see if it helps:

John