Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marlowkoch
Starting Member
18 Posts |
 Posted - 2007-12-04 : 17:20:19
|
| I have created a ssis package to export data to a flat file. How do I get the file to export from yyyy-mm-dd to mm/dd/yyyyy? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-04 : 17:21:24
|
Use the CONVERT function.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
marlowkoch
Starting Member
18 Posts |
Posted - 2007-12-04 : 17:49:42
|
| What I have setup is a data flow that goes from ole db source through row count to flat file destination. Where and how would I put the convert function or what would I use to convert yyy-mm-dd to mm/dd/yyyy? |
|
|
|
|
|
|
date from yyyy-mm-dd to mm/dd/yyyy