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.
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.
ASKER
can we run 2 stored procedures in a ooledb command
if yes then how???
if yes then how???
No, you cannot run two stored procedures in a ole db command
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I exactly did the same thing bu caling one rocedure in to another adn i worked fine
thanks
thanks
your welcome,
Regards,
Regards,
SET FMTONLY OFF
SET NOCOUNT ON
Exec StoredProcedureName
that would run similar to any select statement