title: How to automate the execution of a stored procedure with an SSIS package?
body: <p>I have a stored procedure that gets executed through SQL SSIS using a Execute SQL Task.</p>
  
  <p>The task has the following:</p>
  
  <pre><code>USE [OPPY_DWUSD]
  GO
  DECLARE @return_value int
  EXEC    @return_value = [dbo].[generate_merge_scdbk]
      @Schema = N'dim',
      @Dimension = N'VARIETY',
      @ETLSchema = N'stg',
      @ETLTable = N'vw_VARIETY',
      @Execute = 1
  
  SELECT  'Return Value' = @return_value
  GO
  </code></pre>
  
  <p>Right now the way I have this setup, I have multiple Execute SQL Tasks with the same code but different values, about 20 Execute SQL Tasks.</p>
  
  <p>Is there a more cleaner way to pull this off?</p>