I am transforming my dbaseIII database into a SQL. My
Source Database has a field with Identity set to "Yes". I
want to convert my dbaseIII format dbase getting only two
fields and perform my autonumbering in source database.
How can I do that?

When you say Source do you mean destination.?

Does Dbase III have autonumber?

If you want to simply transfer those attributes from dBase III and have SQL
Server assign the identity OR
You want to transfer the data and the source (dBase III) autonumber
attribute into a SQL Server identity attribute then have a look here

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

If I have misinterpreted the requirement then please post back with more
details

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Robert Vergara" <anonymous (AT) discussions (DOT) microsoft.com> wrote

In the transformation you can use a query to import just the columns you
want ot pull from the DBase III file. Then in the dsetination columns just
select the columns in the SQL Server table minus the identity column.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Hello all,

I have a set of legacy applications that use dbaseIII+, containing
English, as well as data in ISCII format. These have to be transferred
to SQL Server. I am working on an XP with SQL Server 2000 installed.

In the DTS' Import/Export wizard, after the data source has been
selected as 'Dbase III', the file name containing the data, and user
name /password are asked (There is _no_ username/password feature in
dbaseIII). After giving the file name, if the user name and password are
not given, the following error message comes up -

"Invalid date setting in the Xbase key of the Windows Registry".

If, along with the filename, the user name / password combination is
entered (the one used at the time of logging in), then the following
error message is thrown -

"Cannot start your application. The workgroup information file is
missing or opened exclusively by another user."

RegEdit on the key -
HKEY_LOCAL_MACHINE\software\microsoft\jet\4.0\engi nes\Xbase - date
showed the data equal to 'MDY'. I changed this to 'MM/DD/YY'. Still no
dice.

This same error of "Invalid date setting ..." appears when i try to do
an import on the dbase file in Access 2003. Though, in the Access
2003/Import window, upon specifying the file type as 'dbaseIII', all the
files are listed properly, indicating that the files as such are
being recognized correctly by the system.

What could be the reason for this problem, and how does one correct it.
Any pointers that could resolve this problem would be appreciated.

Regards,

Sanjay.


P.S. : The dbaseIII+ file has no dbt, no index associated. There is no
'date' field also. There is no password-protection either.



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!