Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It's actually very easy to do.
You have to do it per constraint as far as I know. I'd go through books online on constraints for more details. There may be an option to ignore constraints buried in BULK INSERT or the SSIS bulk insert task. If there is I don't remember it.
=============================================== Creating tomorrow's legacy systems today. One crisis at a time.