Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    10

    Unanswered: sending output from xm_cmshell into Excel using DTS

    Is there a way of running an OS command via xp_cmdshell and sending the results to a spreadsheet within a DTS package ?.

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool sending output from xm_cmshell into Excel using DTS

    Yes, but why????????????

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool sending output from xm_cmshell into Excel using DTS

    Yo pookie, why dont you just use dts to run the whole thing. create a bat file for the stuff you want for exel. Use the dts utitlity to bring that data into sql 2k and clean the data up while your doing in. Doooooh

    Rookies

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •