Calling stored procedure in SSIS

[hedgracer]

How do I call a stored procedure in SSIS? I have googled this to death and have yet to find something I can use. Any help is appreciated (including a link that I can go to for reading up on this procedure). Thanks.

Dave Christman

 

[gradley]

You need to use an Execute SQL Task. In the SQLStatement section you can add the code to execute the stored procedure.

If you need to pass parameters, use the ? syntax and specify the parameters in the "Parameter Mapping" section.

 

[gradley]

Here is a link from SQLIS that may be useful:

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

 

[DanEvans]

Another option is to use expressions in the execute sql task editor. You could create an expression for the SqlStatementSource property. A simple example:

"exec usp_SomeProc @somevar = '"+ @[User::strSomeVar]+"'"

Thanks,
Dan