call a stored procedure with passing parameter

Here are my objectives:
1.) Generate a GUID value
2.) using "Reader" under Transformation, select a stored procedure and pass the GUID value
3.) this stored procedure will return number of columns and rows
4.) from "Reader" to "Validator" node to validate some value returned by the stored procedure
5.) from "validator" to "transformer" to select some fields and save it to another table.

Perhaps you can post dummy stored procedure source?

Than we will be able to create a working example for you

Mike

CREATE TABLE TBL_DATA
(
A VARCHAR(50),
B VARCHAR(24),
X INT IDENTITY(1,1) PRIMARY KEY
)


GO


CREATE PROC tsp_GetWork
(
@P VARCHAR(50)
)
AS
SELECT * FROM TBL_DATA
WHERE A = @P

GO

INSERT INTO TBL_DATA (A, SELECT 'DANIEL','CANADA'
INSERT INTO TBL_DATA (A, SELECT 'JUDY','CANADA'
INSERT INTO TBL_DATA (A, SELECT 'ORLANDO','CANADA'
INSERT INTO TBL_DATA (A, SELECT 'STEVE','USA'
INSERT INTO TBL_DATA (A, SELECT 'JEB','USA'

Theres is no need to use stored procedure in your case
But if you want to you can do something like this





Mike

my requirement is to pass a GUID to the stored procedure.
Now, how do i generate a GUID and pass it to a variable <VariableName> and pass it to a Data Reader?

Download and install latest version

and use script object to assign value to the variable



Mike