Post reply

Multiple extracts using DTS

  • May 4, 2012 at 12:15 am

    #74731

    i have stored procedure which returns two results.

    CREATE PROC usp_sample

    AS

    select * from employees

    select * from Department

    Now i have to export the two results sets data to two csv files with names

    employees.csv and department.csv.

    How i can achieve this fuctionality using DTS in sqlserver 2000.

    Please help me ................

  • May 7, 2012 at 12:59 am

    #1483971

    Can anyone please help me hoe can i achieve this functionality.

    Quicker responses are appreciated..

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply