Post reply

Multiple extracts using single DTS

  • May 4, 2012 at 4:26 am

    #273576

    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 package in sqlserver 2000.

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

  • May 4, 2012 at 4:43 am

    #1483459

    You should try posting this in the DTS forum.

    This one is for SSIS.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • May 4, 2012 at 4:47 am

    #1483461

    Posted long back but no replies

  • May 4, 2012 at 5:53 am

    #1483476

    Guys please help me the one who knows about the DTS packages

  • May 4, 2012 at 8:40 am

    #1483605

    I think the point that really needs to be brought is that no new development should be done in DTS and especially in SQL 2000. SQL 2000 has been end-of-life for 3 years.

    I think the hesitation you are getting is tied to you wanting to do something you probably shouldn't.

    CEWII

  • May 7, 2012 at 6:05 am

    #1484042

    i can't just go and design in SSIS because by businees client still using the SQL 2000 server so i should develop only using DTS.

  • May 8, 2012 at 2:37 pm

    #1484777

    Since it appears my original response didn't go through..

    I get your point and will help ya but first..

    I am obligated to point out that SQL 2000 is end of life and support is limited, this means that should there be a problem that your client has limited support options. They need to be goaded into upgrading. At this point if they don't at least have a plan to upgrade they are risking business disruption and potentially a forced upgrade. So this could be a good opportunity to stress this need.

    You can accomplish what you want by adding a SQL connections. Then add two flat file connections (I believe they are called, its been a while since I was in DTS) and set them up. Connect the source to each destination. Double click on each connection and enter the source query and then map to the destination. This should get you there or close.

    CEWII

Viewing 7 posts - 1 through 6 (of 6 total)

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