Difference in Job Export (.dsx file)

mandar84 · Post by **mandar84** » Wed Jul 22, 2009 4:32 am

Hi,

I have taken export of the same Job from two different locations (servers).

When I ran compare utility on these export files, I found a few messages in one of the files like-

Link_Name.Col_name = (NullSetVar0 == 1) ? set_null() : Link_Name.Col_name;

There were other columns as well for which same message was displayed. These columns are used in a transformer.

However, on checking the code manually, there was no difference in the code of the two Jobs.

Reuest you to please share any information you have on the above scenario.

Regards,
Mandar

ArndW · Post by **ArndW** » Wed Jul 22, 2009 4:40 am

Do you mean that this line is in one file and not the other? You should also post a couple of lines above and below, at leas to find out in which .dsx file section they appear.

mandar84 · Post by **mandar84** » Wed Jul 22, 2009 5:11 am

Yes, that right...its present on on file and not on other. As requested the code from the file is as -

if ((trim_leading_trailing(StageVar0_SVar1) == InterVar0_29)) {
NullSetVar0 = 1;
} else {
Link_Name.Col_Name = trim_leading_trailing(StageVar0_SVar1);
} Link_Name.Col_Name = (NullSetVar0 == 1) ? set_null() : Link_Name.Col_Name;
NullSetVar0 = 0;

The code in blue is present on both files, but as mentioned there is an extra line in one file.

ArndW · Post by **ArndW** » Wed Jul 22, 2009 5:16 am

I will guess that the extra code is in the original and you are seeing an artefact. If you were to do a force compile on the original and copy and compare the .dsx files they should be identical.

mandar84 · Post by **mandar84** » Wed Jul 22, 2009 6:01 am

Hi, I tried as suggested(force compile), but no success.

ArndW · Post by **ArndW** » Wed Jul 22, 2009 6:03 am

Which one has the extra text? Which section of the .dsx file is it in?