Export of BIGINT becomes INT

• 2farqm

  SSC Rookie

  Points: 39

  More actions

  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

• Leon Platt

  SSCommitted

  Points: 1921

  More actions

  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