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.

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


"ChrisR" <anonymous (AT) discussions (DOT) microsoft.com> wrote