I have a simple ETL from CSV to SQL Table.

here is the current workflow (see picture attached)

• first object is a Flat file source
• then a lookup
• lookup match will update existing record (OLE DB Command – Execute stored procedure)
• lookup no match will insert into SQL table (OLE DB Destination)

Here is the problematic csv data

data type for Number is Integer. So obviously Phil is throwing an error

Now I want to always replace “?” with zero

how do I do that? thank you