Post reply

DTS from multiple tables to single textfile

  • October 28, 2002 at 5:52 am

    #151757

    I have to export data from master/child tables to textfile so that after master data line comes child data lines and then next master line and so on. Is it possible to do this with DTS?

    Heiki

  • October 28, 2002 at 8:58 am

    #439599

    It would be possible to do this with an ActiveX script and two recordsets. However, you should look in Books OnLine (in SQL Server online documentation) for Data Shaping...you can write one query that will organize your data hierarchically...

    hth,

    Michael

    Michael Weiss


    Michael Weiss

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

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