Post reply

editing query in Data Transform Task of DTS -- gives screen invalid mappings,create new mappings

  • July 15, 2006 at 5:54 pm

    #649422

    ok.. I was trying diff options and here is what I found out... when iam querying using single table then no matter how many times I change transformation and create copy column transformation it works fine...i.e. after i click test button on Transformations tab... problem is coming when I have a join condition in the query and that too when i select columns from both the tables. For example this doesnt work...

    select employee.employee_no,employee_address.primary_city from employee

    join employee_address on

    employee.employee_no = employee_address.employee_no

    Error message>>>>>>

    ---------------------------

    ---------------------------

    A DTSTransformCopy must specify no columns (signifying a sequential 1-to-1 mapping of all columns) or the same number of source and destination columns.

    but if i remove the second column in this query i.e employee_address.primary_city then it works fine....

    any ideas guys...

    Thanks in advance

Viewing post 1 (of 2 total)

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