Problems when migrating from Sybase to MS SQLSERVER 2000

#1

We created a dts to create a table from our Sybase DB and when we run
the dts everything is ok but when we check the data we found that the
numeric columns had been created with a 0 value instead of their
original value. What may be wrong?

Thanks,
JR

#2

Looks like some driver conversion of the values is happening.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"JR" <juliagrodriguez (AT) hotmail (DOT) com> wrote

Quote:

We created a dts to create a table from our Sybase DB and when we run
the dts everything is ok but when we check the data we found that the
numeric columns had been created with a 0 value instead of their
original value. What may be wrong?

Thanks,
JR

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

Problems when migrating from Sybase to MS SQLSERVER 2000

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

Problems when migrating from Sybase to MS SQLSERVER 2000 - 10-07-2004 , 12:01 PM

Re: Problems when migrating from Sybase to MS SQLSERVER 2000 - 10-09-2004 , 06:16 AM