Re: Table difference xml output differs

[Ivan Peev]

Hi Thijs,

From the description below I suspect you are hitting a well known serialization bug in SQL 2012. This bug has been fixed in CU3. The CU3 announcement is here.

Please keep in mind CU3 contains more fixes compared to SQL 2012 SP1. So installation of SP1 will not solve the issue. You have to install CU3.

On Friday, January 25, 2013 6:20:47 AM UTC-5, thij...@gmail.com wrote:

Hi

I am trying to move a ssis project to a new server.

Both servers : SQL server 2012 installed + CozyRoc 1.6.(sp packages updates)

Both servers seem the same. (both server never had any old sql servers installed or something like that)

When i make a simple project on both server the table difference xml output differs.

Old server

name="NewInputLineageIDs">

                  <arrayElements

                    arrayElementCount="14">

                    <arrayElement

                      dataType="System.Int32">#{Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Address]}</arrayElement>

New Server:

    name="NewInputLineageIDs">

                  <arrayElements

                    arrayElementCount="14">

                    <arrayElement

                      dataType="System.Int32">56</arrayElement>

So the new server doesnt use name based Lineage IDs.  I have tried serveral things but cannot seem to get the new server to use name based Lineage IDs.

When i open one project on another server it generates errors (from new to old as from old to new).

I really need for the new server to use name based lineage IDs as wel

Is this configuration, did i forget to install something??

Any help would be appreciated!

Thanks

Greetz Thijs

[Ivan Peev]

Hi Thijs,

The correct behavior is lineage by NAME.

On Saturday, January 26, 2013 6:54:07 AM UTC-5, thij...@gmail.com wrote:

Unfortunately it dit not help my situation.

Do you now what the correct xml should be, lineage by ID or lineage by NAME

Op vrijdag 25 januari 2013 14:16:58 UTC+1 schreef Ivan Peev het volgende: