Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-30 : 10:56:29
|
Sue writes "I do a lot of data imports from Access to SQL and have come across a recurring problem....when I try to import into a sql table that contains an identity column, my package fails with an error message stating that I can't insert a NULL into an identity column. My identity column is not listed in my transformations as a column at all. I do not have this problem with SQL to SQL packages, only Access to SQL packages. My solution to the problem is to include tasks that drop the identity column before the inserts and then add it again afterwards, but I'd like to find a more nifty* solution, if possible.
Thanks,
Sue
*Nifty = only one task" |
|
|
|
|
|
DTS - MSAccess to SQL