Bill W
2009-11-17 15:10:47 UTC
Hey,
I have an import from a flat file that has 70 plus rows. One row's
counterpart is an int. One row failed, it contained a space, where the
acceptable values are 0, 1, 2, and 3. Business rules state if two
other fields = zeros, I can put a 0 in the field.
How can I check DTSSource("002") and DTSSource("017")'s values at
DTSSource("027")'s transformation step?
I tried creating Globals and at 002 create an extra transform that
sets DTSGlobalVarialbes("ArNumber").value = DTSSource("002"). I do not
get the value of 002 in the Global. I put a MsgBox display and it
shows the value... but it apparently does not stay valid until 027!
Same with other field.
Is this even possible? Any Ideas?
Thanks,
Bill
I have an import from a flat file that has 70 plus rows. One row's
counterpart is an int. One row failed, it contained a space, where the
acceptable values are 0, 1, 2, and 3. Business rules state if two
other fields = zeros, I can put a 0 in the field.
How can I check DTSSource("002") and DTSSource("017")'s values at
DTSSource("027")'s transformation step?
I tried creating Globals and at 002 create an extra transform that
sets DTSGlobalVarialbes("ArNumber").value = DTSSource("002"). I do not
get the value of 002 in the Global. I put a MsgBox display and it
shows the value... but it apparently does not stay valid until 027!
Same with other field.
Is this even possible? Any Ideas?
Thanks,
Bill