Home Forums SQL Server 2005 SQL Server 2005 Integration Services create a SSIS package which will call the stored procedure and dump the output of the procedure into table RE: create a SSIS package which will call the stored procedure and dump the output of the procedure into table

  • January 21, 2011 at 5:18 am

    #1276481

    Try something like below...

    SET NOCOUNT ON

    exec sp_name @UserDate = ?

    and pass parameter in Parameters Tab (@UserDate = <Variable Name>)