Using stored Procedure in DTS Package

• eseosaoregie

  SSCertifiable

  Points: 6889

  More actions

  November 14, 2008 at 10:42 am

  #71678

  I am trying to create a package that runs a stored procedure to create an output that is then exported to Excel. The stored procedure takes 2 variables as dates. I do not understand how to include the variables as parameters in the package. Any help on this topic would be much appreciated.

  Regards

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 14, 2008 at 10:46 am

  #898752

  This is a good article with examples. It helped me when I was trying to figure out how to do this.

  http://www.sqldts.com/234.aspx

  Greg