Trying to use the DTS Wizard to Import data from one table into another. The
problem is that the source table has DateTime data and I have to fit it into
a VarChar column. The problem is that the DTS Wizard is changing the format
of my data so that source column data 12/30/2005 becomes 2005-12-30. I have
to keep the data in 12/30/2005 format. Does anyone know how to force DTS to
format the data that way?

Thank you!

PSRDCJIM wrote:
Simplest way would be to use a source query, and convert before it hits
DTS, so DTS just transfers the varchar data. No risk of DTS or anything
else getting confused.

The reason why it ends up in that format will be some "client" date
format setting.

--
Darren
http://www.sqldts.com
http://www.sqlis.com