Reformatting the date in DTS

#1

Hello

My DTS transformation is fighting with me.

I am exporting a smalldatetime field from a SQL Server table to a text file.
The requirements of the text file is that only the date (not the time) is
put into the file. And the date must be in YYYYMMDD format. This seems
amazingly simple but
I can't get the transformation to work. I continue to get YYYY-MM-DD.
....grrrrr.

Can anyone help without mocking my ignorance?

. Okay, you can mock it.

#2

CONVERT(CHAR(8),<smalldatetimefield>,112)

"Steve" <pezguy (AT) mn (DOT) rr.com> wrote

Quote:

Hello

My DTS transformation is fighting with me.

I am exporting a smalldatetime field from a SQL Server table to a text file.
The requirements of the text file is that only the date (not the time) is
put into the file. And the date must be in YYYYMMDD format. This seems
amazingly simple but
I can't get the transformation to work. I continue to get YYYY-MM-DD.
...grrrrr.

Can anyone help without mocking my ignorance?

. Okay, you can mock it.

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

Reformatting the date in DTS

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

Reformatting the date in DTS - 04-12-2005 , 12:34 PM

Re: Reformatting the date in DTS - 04-12-2005 , 01:22 PM