I would like to add records to an existing table but only with data in selected columns leaving the rest un-populated. Of the columns that are not included are ones that are specified as non-null, including some numeric fields.
In the past, I have been able to do this by using the Tasks -> Import Data wizard in SSMS. Suddenly, this has stopped working giving an error message about trying to put NULL data into a non-null column (see the error message in the 2nd image regarding the ADCOST column in the dbo.ADCOSTS table. The columns in green (commented out) are just my notes for which columns to include and are not part of any commands.
Something has changed that now prevents me from doing something that I had been for several years. Either that, or I've changed something, but I can't find what that would be.
I've attached a couple of images that might help. It shows the table to be appended and the columns that I wish to include.