>Would the -E switch help ?
>
>-E
>Specifies that identity value or values in the imported data file are to be used for the identity column.
>If -E is not given, the identity values for this column in the data file being imported are ignored,
>and SQL Server automatically assigns unique values based on the seed and increment values specified during table creation.
>
>
>
http://msdn.microsoft.com/en-us/library/ms162802(SQL.90).aspx>
>
http://msdn.microsoft.com/en-us/library/ms186335(SQL.90).aspxThanks, this is good to know. I will probably end up using a method of the framework I have as it takes care of everything, such as recreating the table and indexes.
