Hi, I'm new to sql...

I want to transfer data stored in an MS Access database into SQL2000. When
the process is complete I find that the dts process does not:

a. convert autonumber fields into identity(1,1) columns.
b. set default values for columns

I can use enterprise manager to edit the package but this will take a while...
I can edit sql whilst in the dts wizard which will take a while...

I am wondering if there is a better way perhaps a way that I can save the
dts package as a text file (so that I can prgramatically set
defaults/constaints)?

Many thanks

Jonathan

When moving the data that is all that happens. Using the datapump you
simply move data nothing more. Moving from Access to SQL Server you
have no other options than to apply the Identity + default vaues
after/before the datapump. You could write a little application that
did this for you by reading the metadata from Access and applying that
to the SQL Server version of the table. You could also create your
tables up front before pumping data into them.

Allan

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

Allan, thanks for confirming this...

Jonathan

"Allan Mitchell" wrote: