"red_ferrari" 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:
>
> > 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@discussions.microsoft.com> wrote in message
> > news:79FCDB4E-578A-4262-A155-5CE235E3796E@microsoft.com:
> >
> > > 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.
> >