I have set up an integration that looks for a specific csv file and takes the information in the file and inserts it into a sql database table. In general it works as long as I exclude the numeric field. 

My csv file looks like this:

I have created integration variables for each of the fields.

In my sql table, I have tried data types INT and Numeric and neither will work.

When I connect to the sql table through the Database Connection Setup in the action, the Type field shows Integer, but in the Record Value section of the action, all data types are Text. 

I have tried customizing my sql statement and converting the field to an Integer, but that isn't working either. I tried substituting the NumberSerials variable with the number 2 but couldn't get that to work either (I was just trying to test the sql command). I was able to successful run an insert command with the data directly in my sql database, so I don't think my table is incorrect.

Any suggestions for how I can get this to insert my number field as a number and avoid the error?

Thanks,
Kendra