Post reply

Export of BIGINT becomes INT

  • April 22, 2002 at 8:05 am

    #105233

    Hi,

    I was wondering if you have come accross the following problem. (SQL SERVER 2000 SP 2)

    When you export a table with a bigint from one database to another on the same machine a bigint is changing value. It appears that the bigint (8byte) is being truncated to int(4byte) and back again.

    This might have something to do with the ODBC driver ?

    Have you see this before ?

    Thanks,

    John

    d_b_a@ireland.com

  • April 22, 2002 at 7:55 pm

    #427642

    I don't see the problem on my sql 2000 box sp1. Why are you using ODBC? Why not the SQL OLE DB Provider for sql server? Do you know how to read visual basic code? you could save the DTS package as a Visual Basic File, open it up in Visual Basic and see what it is actually doing. To do this click Package-->Save As--> choose Visual Basic File in the "Location" DropDown box. Good Luck

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply