DTS error

#1

My error in schedule DTS is:
DTSRun: Loading...
DTSRun: Executing... D
TSRun OnStart: Transfer SQL Server Objects
DTSRun OnError: Transfer SQL Server Objects, Error = -
2147221296 (800400D0)
Error string:
Error source:
Help file:
Help context: 0
Error Detail Records:
DTSRun OnFinish: Transfer SQL Server Objects
DTSRun: Package execution complete.
Process Exit Code 1.
The step failed.
What can I do ?

#2

Look at the definitions of the two columns "tdate". Are they the same ? By
the looks of things they are not.
Have a look at the source and look for data that will not fit into the
destination

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Brennan" <bwashington (AT) covad (DOT) net> wrote

Quote:

Hello:

I have created a DTS Package that moves the data from some
tables and views from several databases to a reporting
database. After the moves are done, the package then runs
a series of SQL tasks designed to clean up the data.

I am in the process of testing the package and after
running successfully for a few days, 2 of the steps are
failing with the following error:

Error Source: Microsoft Data Transformation Services (DTS)
Data Pump

Error Description: DTS TransformCopy: Schema Validation
Failed; See Extended Error for Information
TransformCopy 'DTSTransformation_3' validation error:
Source column too narrow to contain a valid destination's
column for column pair 1 (source
column 'tdate'(DBTYPE_STR), destination
column 'tdate'(DBTIMESTAMP_STR)).

I have no idea what this means or how to fix it. Any
comments or suggestions would be appreciated

Thanks
Brennan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS error - 06-30-2003 , 11:16 AM

Re: DTS Error - 07-01-2003 , 01:34 AM