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