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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>