Dts

[ichervin]

Hi All,

I have a table in Access that I am bringing to a database in SQL Server. I have created a table in that database and my PK field using the identity property. When I run the DTS to bring the Access table into my database, I get an error message at the end of the process:

Destination does not allow NULL on column pair 1.

Am I getting this error because the first column in the table in SQL Server database is not null?

Can I chabge the first column to NULL, run the DTS process and once the data is in the SQL Server table change it to NOT NULL?

Do you see any problems with it?

[rmiao]

Enable indentity insert in dts data transformation.

[ichervin]

Do I do that when I am setting up DTS?

[ichervin]

Please disregard my reply. I am good. Thanks for your help.