Wednesday, March 7, 2012

How do I execute a stored Procedure using SSIS

SmilePlease anyone help me with my question

How do I execute a stored Procedure using SSIS ?

I have a stored procedure in SQL SERVER 2005 database that I need to execute using a SSIS package using Execute SQL Task from Toolbox in Visual studio 2005

Thanks,

George

It's been awhile, but don't you just type in this into the sql statement slot:

exec my_procedure_name_here

|||

Thanks for your help

How do I do thisexec my_procedure_name_here

What I have to do in SSIS the steps..please

Thanks again

George

No comments:

Post a Comment