[Last Call] Learn how to a build a cloud-first strategyRegister Now


error copying bigint values through DTS package

Posted on 2005-05-10
Medium Priority
Last Modified: 2010-03-19
hi experts,

I have a strange behavior in my DTS package when copying tables with bigint values.
e.g. data 123456789 will become somethimg like -809823092 in the destination table.

I can resolve this when unchecking allow null values in the source table for this field  !?
Unfortenatly I have also a table WITH null values...

any idea?

Question by:duke63
  • 3
  • 2

Author Comment

ID: 13966755
Might be of interest...

Our Microsoft SQL Server Versions

Source DB: 8.00.760  1  3
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
      Dec 17 2002 14:22:05
      Copyright (c) 1988-2003 Microsoft Corporation
      Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Destination DB: 8.00.760  3  2
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
      Dec 17 2002 14:22:05
      Copyright (c) 1988-2003 Microsoft Corporation
      Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Expert Comment

ID: 13967622
does your other database table  has the datatype bitint

LVL 28

Accepted Solution

rafrancisco earned 800 total points
ID: 13968269
This also happens to me when copying across different servers.  The only workaround that I do is to create the destination tables first before performing the import/export.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 13976938
Yes Julianva.
rafrancisco, I thought this is allready done with activated "drop destination objects first" option in my dts package.
LVL 28

Expert Comment

ID: 13978185
duke63, somehow even if you have activated the "drop destination objects first", it still doesn't transfer bigint properly.  You really have to create the table first as a separate step before copying the data for the bigint to be properly copied.

Author Comment

ID: 14058964
Thanks rafrancisco !

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question