title: How to use stored procedures within a DTS data transformation task?
body: <p>I have a DTS package with a data transformation task (data pump).  I’d like to source the data with the results of a stored procedure that takes parameters, but DTS won’t preview the result set and can’t define the columns in the data transformation task.</p>
  
  <p>Has anyone gotten this to work?</p>
  
  <p>Caveat:  The stored procedure uses two temp tables (and cleans them up, of course)</p>