tags:

views:

93

answers:

1
Q: 

Error while running DTS package: SQL Server 2000

Hi, could any one help me to resolve this issue.

I'm executing a DTS package on my system from SQL Server Enterprise Manager by connecting to the Database Server (Remote server). The execution completes with the error message

"DTSStep_DTSDataPumpTask_1:Error at Destination for Row number . Errors encountered so far in this task:"

This process try to upload a txt file to the database. The text file can contain some null values in the columns.

But the strange thing is, my collegues/from other systems, I could able to run the same packages. I really got stuck here why its not working on my PC. Here is the environment I'm using.

Environment: Operating System: Windows XP Sp2 SQL SErver: SQL Server 2000 MS SQL Enterprise Manager: Version 8.0

A: 

Perhaps there is a column in this database that is set to not allow nulls?

See also http://support.microsoft.com/kb/228933

Robert Harvey  2009-06-12 17:00:56

related questions

Is there a "poor man's" alternative to RedGate for scripting out entire database schema?
My SQL Server 2000 Transaction Log Size Seems Small
Is there a way to script diagrams in SQL 2000 (or save them another way)?
Programatically renaming a table in SQL Server 2000 - is sp_rename the only solution?
I am getting a "fatal error 7987" error from SQL Server 2000
SQL Server 2000 and System.Transactions.TransactionScope()
Why should I upgrade from SQL2000 to SQL2005?
Can I protect against SQL Injection by escaping single-quote and surrounding user input with single-quotes?
Passing timestamp parameters in SQLAnalyzer to debug stored procedures
Linked Server Performance and options
SQL Server 2005: Importing data from SQL Server 2000
How do I perform a case-sensitive search and replace in SQL 2000/2005?
Warm Backup
Benefits of SQL Server 2005 over 2000
How can I create a human-readable script for every DTS package on a SQL server?
Deleting Rows from a SQL Table marked for Replication
In what situations would you get different users seeing different rows in a table on SQL Server?
Date object last modified
Improving SQL Server performance on VMware under Linux
The log file for database is full.
SQL Server 2000 - Debugging Deadlocks
Strategy for identifying unused tables in SQL Server 2000?
In SQL Server 2000, is there a sysobjects query that will retrieve user views and not system views?
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
How do you deal with transport-level errors in SqlConnection?