DTS utilizing stored proc

I am trying to create a DTS package to send results from an extended stored
procedure [master.dbo.xp_fixeddrives] to an Access table.
What is the best Task to use in order to call an extended stored procedure
in DTS?
Message posted via http://www.webservertalk.comhi,
Just a Execute SQL Task
cheers,
"Robert Richards via webservertalk.com" wrote:

> I am trying to create a DTS package to send results from an extended store
d
> procedure [master.dbo.xp_fixeddrives] to an Access table.
> What is the best Task to use in order to call an extended stored procedure
> in DTS?
> --
> Message posted via http://www.webservertalk.com
>|||Since this extended procedure returns multiple rows, is there a way to
insert these rows all at once into my Access connection? I am not seeing
how to do that in a Execute SQL Task.
Message posted via http://www.webservertalk.com