sql server dts: Lotus Notes database transfer to SQL 2000 table having identity co -- sql server dts

Re: Lotus Notes database transfer to SQL 2000 table having identit

vilas
8/1/2006 7:55:03 AM

Hi Alan,

Enable inserts is on and I am not passing any field to populate the
identity column. Also, destination identity column is not mapped to any
source column. It throws an error after the last row saying nulls cannot be
inserted in the identity column.

Vilas

[quoted text, click to view]

Re: Lotus Notes database transfer to SQL 2000 table having identity co

Allan Mitchell
8/1/2006 1:47:34 PM

So the first thing I would check is

1. Have you told it to enable identity inserts?
2. If you have are you passing a column to populate this field?
3. If you are passing a value to this field is that source value NULL?

--

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

[quoted text, click to view]

Re: Lotus Notes database transfer to SQL 2000 table having identit

Allan Mitchell
8/1/2006 4:09:47 PM

You have told SQL Server to expect values in the identity column and then
pass nothing to it. You need to hook up a column from the source to this
destination column. It waits until the end to tell you this but they will
all be failing

--

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.