Link to home
Start Free TrialLog in
Avatar of kakarlapudidivya
kakarlapudidivya

asked on

run a stored procedure in dta flow task of ssis

Hi All,

Currently I am running a stored procedure in a oledb command and using the output in my other tasks .

My stored procedure updates a column by one number in a loop but oledb command does only one row per dataset.its resulting the same barcode number to all columns.

so i need to know a way to run my stored procedure in data flow and capture results.
Avatar of vdr1620
vdr1620
Flag of United States of America image

You can use

SET FMTONLY OFF
SET NOCOUNT ON

Exec StoredProcedureName

that would run similar to any select statement
Avatar of kakarlapudidivya
kakarlapudidivya

ASKER

can we run 2 stored procedures in a ooledb command

if yes then how???
No, you cannot run two stored procedures in a ole db command
Avatar of Reza Rad
look at my post here:
http://rad.pasfu.com/index.php?/archives/24-Output-Parameter-of-Stored-Procedure-In-OLE-DB-Command-SSIS.html

does it what you looking for exactly?
if not explain more about what you want to do
ASKER CERTIFIED SOLUTION
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I exactly did the same thing bu caling one rocedure in to another adn i worked fine

thanks
your welcome,
Regards,