SQL Server - Assign Global var in Transformation Active X

Asked By Bill W

17-Nov-09 11:53 AM

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

19-Nov-09 05:16 PM

Ok, I figured it out... You do not have to use a Global Var.  Just
refrence the colums in the datapump transform step and you can check
the values of those columns (002, 0017,...) then do your comparisons
on those colums to match your criteria, use your If-Then-Else stmts to
do your work.  Actually pretty simple.  :)
Thanks for trying....
Bill