How can I get return value from a stored procedure and use it in script task using OLE DB Command Task(Provider, Providerlocation) in SSIS?

Question

How to get return value from OLE DB Command Task and use it in Script task?

Actually i have a flat file to insert using stored procedure i have to get return values for each and every row inserted. how can i get the return value in oledb command task? — user2326218, Feb 26 '17 at 13:56

score -1 · Answer 1 · edited Feb 27 '17 at 06:35

-1

You can use Execute SQL task to execute the stored procedure and the returned value from the stored procedure then be set to a variable(i.e map the returned Result set to a variable). This variable can then be used by the script task.

Execute SQL task

edited Feb 27 '17 at 06:35

Hitesh

3,449
8
39
57

answered Feb 27 '17 at 05:19

manoj singh

26
5

How can I get return value from a stored procedure and use it in script task using OLE DB Command Task(Provider, Providerlocation) in SSIS?

1 Answers1