InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:05:11 GMT20http://www.sqlservercentral.com/Forums/Topic819581-19-1.aspxHey,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,BillMon, 16 Nov 2009 11:52:52 GMTbwillyerd