1 of 1 people found this helpful
Hudi. you do not need to single quote numbers. I'm assuming that the student_id is an integer primary key and auto-enter by SQL.
IN (10,1000,10000,10006, ...) would be the correct format for the SQL statement (whether using Import script step or ExecuteSQL function).
Thanks for the tip. The issue was that I had the sql field name in single quotes making it a literal string.