Sql 2k5 DTS Date Transformation

#1

I am trying to find a transformation object that does the
same thing as a sql2k DTS Date Transformation (IE within a
datapump)

I have a datetime field, and I am trying to extract the
value and change the date format. For example I would like
to specify the output to be yyyymmdd. I could use use a
derived column object and perform datepart functions, but
it seems like an awful lot of work to do something this
common.

Any suggestions would be appreciated.

#2

Is this all from SQL Server?

If yes then could you not specift something like this in your statement

SELECT......... CONVERT(CHAR(8),Getdate(),112)....................

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"rmartinez" <rmartinez (AT) procard (DOT) com> wrote

Quote:

I am trying to find a transformation object that does the
same thing as a sql2k DTS Date Transformation (IE within a
datapump)

I have a datetime field, and I am trying to extract the
value and change the date format. For example I would like
to specify the output to be yyyymmdd. I could use use a
derived column object and perform datepart functions, but
it seems like an awful lot of work to do something this
common.

Any suggestions would be appreciated.

#3

I understand I can do it if I use a query to extract the
dataset.
I am trying to figure out how to do it using sql2005's dts
transformation objects.

Quote:

-----Original Message-----
Is this all from SQL Server?

If yes then could you not specift something like this in
your statement

SELECT......... CONVERT(CHAR(8),Getdate
(),112)....................

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"rmartinez" <rmartinez (AT) procard (DOT) com> wrote in message
news:2f1601c4ad7d$0228ebd0$a601280a (AT) phx (DOT) gbl...
I am trying to find a transformation object that does the
same thing as a sql2k DTS Date Transformation (IE
within a
datapump)

I have a datetime field, and I am trying to extract the
value and change the date format. For example I would
like
to specify the output to be yyyymmdd. I could use use a
derived column object and perform datepart functions,
but
it seems like an awful lot of work to do something this
common.

Any suggestions would be appreciated.

.

#4

In message <40e501c4af99$71e0ee00$a601280a (AT) phx (DOT) gbl>, rmartinez
<rmartinez (AT) procard (DOT) com> writes

Quote:

I understand I can do it if I use a query to extract the
dataset.
I am trying to figure out how to do it using sql2005's dts
transformation objects.

Derived column or Script Transform would be my choices.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

Sql 2k5 DTS Date Transformation

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

Sql 2k5 DTS Date Transformation - 10-08-2004 , 04:23 PM

Re: Sql 2k5 DTS Date Transformation - 10-09-2004 , 06:59 AM

Re: Sql 2k5 DTS Date Transformation - 10-11-2004 , 08:51 AM

Re: Sql 2k5 DTS Date Transformation - 11-05-2004 , 01:13 PM