sql server dts: Hi,

In my sql server 2000 i have the ID field set to identity. when converting
sql server to Access database, i need to set as Auto number field.

Currently its look like this. its createing a field as number. i need to
generate as a auto number into access.
"`ID` Decimal (18,0) NOT NULL"

how to change the qry?

thanks

Create the table up front.

I do not think the wizard will recognise the autonumber property do will
create an attribute of the base datatype

Remember though that this may throw off your PK/FK references.

Also look at this problem when using Identity()

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.konesans.com - Consultancy from the people who know


[quoted text, click to view]