[RESOLVED] Add row to SQL Server table with Primary Key ID field using Identity Specification

[wes4dbt]

That's great advice. Thank you. Is it better not to use the Wizard? Is there a manual way that is better?

I use the wizard all the time but you have to make sure if you modify the database that the dataset gets updated. You can manually create a type dataset, just Project->Add new item->Dataset.