Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS OLE DB error

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2007-07-18 : 04:42:30
Hi pals,

I am getting the following error while executing my DTS package.

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21)
Error string: Invalid character value for cast specification.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0

Error Detail Records:

Error: -2147217887 (80040E21); Provider Error: 0 (0)
Error string: Invalid character value for cast specification.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.


How to avoid this error.

Thanks in advance,
franky





rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-18 : 12:08:59
What does the package do? Enable package logging so you can get error details.
Go to Top of Page
   

- Advertisement -