Post reply

count and data pump

  • January 11, 2008 at 7:24 am

    #71219

    I have a query i want to run and pump the results into another table, everything works perfect but when i add count to my query the source destination disappears on the transforms tab and i get an error "some of your transforms refer to columns that do not exist in your source destination."

    What can i do differently to input this count?

  • January 11, 2008 at 8:53 am

    #767160

    Have you tried assigning an alias to the count (e.g. count(*) as count_num) in the select list? The Transform Data task needs that to map it to a column in the destination table.

    Greg

    Greg

  • January 11, 2008 at 10:00 am

    #767219

    that worked great thanks for the tip

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

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