|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, March 02, 2010 9:54 AM
Points: 116,
Visits: 68
|
|
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.
Any Ideas?
Thanks,
Bill
|
|
|
|
