using a store proc. in DTS package

[pvmurphy]

I'm tryiing to set up a DTS package, I would like to use a stored procedure rather than type in query to gather the information I want to export. I can't seem to find anyway to do is, is it allowed, and if so, how would you go about doing it.

Thanks in advance,

Jim

 

[snag56]

You would use "Execute SQL Task" and specify the sp as follows:

EXEC userschema.mystoredproc

 

[pvmurphy]

snag56,

Belated thanks for your help, I have it working find.

Jim