SQL Server Performance

DTS and Extended Stored Proc

Discussion in 'SQL Server DTS-Related Questions' started by rerichards, Mar 28, 2005.

  1. rerichards New Member

    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?
  2. satya Moderator

    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.

Share This Page