Ali Shah
asked on
Calling a stored procedure in SSIS for each record
Hi Guys,
I want to execute a stored procedure for each record in the source system.
should i use script component or any other transformation / control?
Please note that my stored procedure has got parameters. That means that i would need to pass some of the columns from source as parameters.
regards
I want to execute a stored procedure for each record in the source system.
should i use script component or any other transformation / control?
Please note that my stored procedure has got parameters. That means that i would need to pass some of the columns from source as parameters.
regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
regards