date transformation fails

date transformation fails

Post by Chris » Sat, 24 Jul 2004 08:29:35


sql2k sp3

Ive got a package that transforms a datetime in one table
into a char(10) in the other. Im using the Date Time
String Function to to this. I feed it in a date and time
the way it's stored in a datetime column, it comes out
like 07/22/2004. This is all well and good. But once I
build an identicle package to be used by Replication with
the same transformation, the Distribution Agent blows up
with:

The number of failing rows exceeds the maximum specified.
(Source: Microsoft Data Transformation Services (DTS) Data
Pump (); Error number: )
TransformDateTimeString 'DTSTransformation__2', column
pair 1 (source column 'TransDate' (DBTYPE_WSTR),
destination column 'TransDateShort' (DBTYPE_STR)): Cannot
parse input data string beginning at '2002-12-31 00:00:00'
(Source: Microsoft Data Transformation Services (DTS) Data
Pump (); Error number: )


Why does it work in one place and not the other?


TIA, Chris

P.S. Im going to cross post this in DTS and Replication
because its such a grey area.
 
 
 

date transformation fails

Post by Allan Mitc » Sat, 24 Jul 2004 15:57:46

Could it be Server environmental settings?

When you executed the package it was executed in the context of you. When
Replication does it then it will run on the distributor

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know