DTS Package in a SP

[cguyreports]

I have created a DTS package which imports a small amount of data from an excel workbook into a sql table. I then have an sp that joins a couple tables that produces a result set. Can I have a the beginning of the sp something that triggers or executes the DTS package?

 

[AlexCuse]

if SP runs after DTS package, you can call stored procedure from a SQL Command box within the DTS. There may be a way to do it the other way around, but it seems like DTS calling the SP would be preferable.

Hope this Helps,

Alex

It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.