I have a simple ODBC link where I import an "income" in dollars. There are no
errors, but when i look in my selection it has truncate some of income. It
deletes 2 zero's from the input.

For example, it suppose to be $21000, but is shows up like 210.
But $21111.11 is not effected.
And to make it even more stranger, in the preview mode of the transform data
task it shows the right results.

I have tried to several datatypes, like money, float and int. And all give
the truncated results.

What is the data source that you must use ODBC?

To help us try to recreate.

What is the Source datatype and value and what is the destination
datatype.

Allan

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

Thank you for your interest, here is some more info.

Source: Sybase database
Connection: Sybase System 11
Source Datatype: money N,M1

I tried different destination datatype, but then I saw it already went wrong
at the selection.

To recreate the problem,
1. Start up, Import and Export Data from Microsoft SQL Server.
2. In Choose a Data Source select;
Data Source: Other (ODBC Data Source)
User/System DSN: [the Sybase System connection]
If needed a username and password.
Press Next.
3. In Choose Destination
Destination: Microsoft OLE DB Provider for SQL Server
Database: tempdb
I have SQL Server Desktop Engine with mixed authentication, so I choose
Server: (local)
Select, Use Windows Authentication
Press Next.
4. In Specify Table Copy or Query
Select Copy table(s) and view(s) from the source database
Press Next.
5. Select the Sybase Database, Next.
6. Run immediately, Next
7. Press Finish.

After this I in the table, the truncated money amount.

"Allan Mitchell" wrote:

I forgot to mention I am using
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
(Build 2195: Service Pack 4)


"red_ferrari" wrote: