Yep that was it... Used a create table and casted it as an int and all is good in the hood! Thanks for the help! Don't know...

Actually that might be it.. I am inserting a space in the table and then updating it, but that space isn't declared as an int...

Select a.EventID

,a.Dates

,a.LogTime

,a.TriggerDisplayName

...

the StepID is being pulled via an update statement

Update##UpdateTest

SetStep = b.StepID

From##UpdateTest a, ##TriggerMap b

where a.ProcessID = b.ProcessID

and a.TriggerDisplayName = b.TriggerName

and b.StepRequired = 1

The step is being pulled in from another table and Its an Integer.. Below is a sample of the table that the step is being pulled from..

Create Table...