DTS and Extended Stored Proc | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS and Extended Stored Proc

I am trying to create a DTS package to send results from an extended stored procedure [master.dbo.xp_fixeddrives] directly to an Access table. Since this extended stored procedure master.dbo.xp_fixeddrives] returns multiple rows and multiple columns, what DTS Task or Tasks would be best suited to accomplish this?

Use this create table #FreeSpace(
Drive char(1),
MB_Free int)
insert into #FreeSpace exec xp_fixeddrives … and use that table to export the rows to access database using DTS. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.