Identity field problems with DTS

#1

SQL 7.0

Can you use DTS to insert a CSV file into a SQL table that has an identity
field?

Without the identity field, data imports fine.

Thanks,
Don

#2

Yes you can.

Check out this great article by Allen on identity Columns.

http://www.sqldts.com/default.aspx?293

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

Quote:

SQL 7.0

Can you use DTS to insert a CSV file into a SQL table that has an identity
field?

Without the identity field, data imports fine.

Thanks,
Don

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

Identity field problems with DTS

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

Identity field problems with DTS - 07-12-2005 , 05:01 PM

Re: Identity field problems with DTS - 07-12-2005 , 05:10 PM