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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page