In t-sql, I can insert this date 20050712, to a datetime field, and it works
fine. The date shows up correctlys as 2005-12-07.
When I try to do a data transformation in DTS, using CopyColumn with that
same date, to the same field, I receive an error.
My problem is, I don't always know what the date format is going to be
coming in, so I can't just write an ActiveX Script for that transformation.
But, if it's a valid date field, one would think that SQL would handle it the
same way in DTS as it does in t-sql.
Any thoughts?
--
Mike Voissem
Lead Software Engineer
Donnelley Marketing

Mike,

I the course of many years of DTS development in our company we came to
realization that SQL task is preferable to Data Pump and the latter should
be avoided. What we do is loading data into staging/temp tables via BCP and
then using SQL to disperse data further. SQL can do all and much more then
Data Pump.

Ilya

"Mike Voissem" <MikeVoissem (AT) discussions (DOT) microsoft.com> wrote