Post reply

Multiple destinations from single source

  • April 10, 2003 at 7:05 pm

    #151818

    Is it possible to output to multiple destination tables from one source?

    Eg., if source colA ='A' output to tableA and if source colA = 'B', then output to tableB, etc?

    Thanks,

  • April 10, 2003 at 8:31 pm

    #453825

    If you are using DTS to move the data then this is possible through transformations. You could do this using a VB script transformation. If you need furthur help I could provide a sample.

    Darren

    Darren


    Darren

  • April 11, 2003 at 3:33 pm

    #453957

    Hi,

    Or you can use lookups to perform this...

    http://www.sqldts.com/default.aspx?6,107,277,7,1

    JFB

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

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