Invalid column name SIS ID?
I assume you mean how to get the INSERT statement to execute without error? (A column doesn't &quot;execute&quot;.)
Apparently, there is no column named &quot;SIS ID&quot; in the dbo.eNtsaRegPeopleLists table. That is what the error message is telling you.
You did right by enclosing the column name in square brackets (double quotes is another option). So double-check what the column name really is. Perhaps the square brackets are part of the column name. Or that the space between SIS and ID isn't a space but some other invisible character (like char(255)). We can't say which it is, so it is for you to determine. One option is to do:
EXEC sp_help 'eNtsaRegPeopleLists'

And see what output you get for the column names.