Post reply

DTS doesn't return all columns

  • July 22, 2008 at 6:56 am

    #125023

    Hi all,

    I am trying to create a DTS package to copy data from Oracle to SQL server but DTS query designer doesn't show all column names in the list, it leaves last 5 out.

    When I try to do without query but just with table, then I have the same issue again!

    Am i doing something wrong?

  • July 24, 2008 at 7:28 am

    #847723

    Does the source Oracle query have all of its columns named (i.e for concatenated or calculated columns, you're naming those columns using an alias)? Otherwise those will show up with null column names and you won't be able to reference them in a data transformation.

  • July 24, 2008 at 7:34 am

    #847732

    Very silly of mine, the source server was wrong. there was the same table with same columns just couple of them missing! So I just set the correct server and everything works fine.

    Thanks for the answer.

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

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