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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2008-09-01 : 11:13:26
|
| Hi,I have the flat file with the data 01.08.2008,xyz,yyy01.08.2008,xyz,yyywhich i need to import the data into the column with the datatype - datetime into sql 2005 table. I tried all possiblility in changing the datatype which matches the destination. In the OLEDB Destination the datatype for the column is "database timestamp [DT_DBTIMESTAMP]". I tried the same by changing the DT_STR to DT_DBTIMESTAMP in the Flat file source through Show Advanced Editor page, nothing working as expectation. Your suggestion is highly appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-01 : 11:51:18
|
Have you tried setting the dateformat to DMY?Or, added derived column which takes the column as input and does the necessary transformation there?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-09-02 : 07:35:58
|
| One solution is to use Derived Column with REPLACE():Expression: (DT_DATE)REPLACE([myDate],".","/")Result: 1/8/2008 12:00:00 AM |
|
|
|
|
|
|
SSIS - Flat file to OLEDB Destination