I have a stored procedure that returns a smallint record and only one record.
How can I get SSIS to read that field... I'm using Execute SQL Task...

This is the stored procedure that I'm using which returns a record of 472:

CREATE PROCEDURE [Lookup].[GetAppelleeStyleID]
@StyleID SMALLINT OUTPUT
AS

SET @StyleID = (SELECT CONVERT(SMALLINT, Lookup.CaseLookup.CaseLookupID)
StyleID
FROM Lookup.CaseLookupGroup INNER JOIN
Lookup.CaseLookup ON Lookup.CaseLookupGroup.CaseLookupGroupID =
Lookup.CaseLookup.CaseLookupGroupID
WHERE
(Lookup.CaseLookupGroup.CaseLookupGroupDescription = 'Style')
AND (Lookup.CaseLookup.CaseLookupDescription = 'Appellee'))

I have tried creating the SQL task with a varialbe or using single row
resultset. Nothing is working.

Any assistance in the right direction is appreciated.

I finally figured it out... I set the resultset to None and created an OUTPUT
parameter in the parameter mapping and it worked....

"scuba79" wrote:

Hello scuba79,

You may also like to try

http://www.sqlis.com/default.aspx?58


allan