Identity column in dts

#1

I'm trying to use DTS to upload data via a query statement. The PK is an
identity column. I tried running the query without saying anything about the
PK, thinking it would supply those values (like MS Access does for me) but it
failed because those were left null. What should I do to import my data?
(newbie to DTS)
--
sam

#2

Have a look at this article

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"smk23" <smk23 (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm trying to use DTS to upload data via a query statement. The PK is an
identity column. I tried running the query without saying anything about
the
PK, thinking it would supply those values (like MS Access does for me) but
it
failed because those were left null. What should I do to import my data?
(newbie to DTS)
--
sam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Identity column in dts

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Identity column in dts - 12-28-2004 , 10:21 PM

Re: Identity column in dts - 12-29-2004 , 12:45 AM