DTS to transform Date/Time to Date without time in Text file.

DTS to transform Date/Time to Date without time in Text file.

Post by JFB » Fri, 19 Sep 2003 04:19:22


Hi James,
Using ActiveXscript you can do this:

dateName = Right(Year(Now()), 2)
If Month(Now()) < 10 Then dateName = dateName & "0" & _
Month(Now()) Else dateName = dateName & Month(Now())
If Day(Now()) < 10 Then dateName = dateName & _
"0" & Day(Now()) Else dateName = dateName & Day(Now())
msgBox(dateName )

JFB :)
 
 
 

DTS to transform Date/Time to Date without time in Text file.

Post by Allan Mitc » Fri, 19 Sep 2003 16:02:00

If your source is SQL Server look at

CONVERT(CHAR(8),<datetime col>,103)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.yqcomputer.com/

 
 
 

DTS to transform Date/Time to Date without time in Text file.

Post by James Jaru » Sat, 20 Sep 2003 05:37:52

Thanks you so much this help.

Thanks again


())
message

File
I do