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-11-28 : 11:53:53
|
| I am trying to setup ssis data flow package to export a smalldatetime field to just date only. I have changed the dattype to datbase date [DT_DBDATE] AND ALSO [DT_DATE] but it still exports datetime format. What is the best and easiest way to setup flat file connection manager to only export date and not the time. Do I have to add another setup to convert to date only? |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-28 : 11:59:12
|
| Use the convert function to have it only display the date piece and then export that. |
 |
|
|
|
|
|
Exporting to Flat file with Date only