View Single Post
 
Old September 1st, 2008, 10:13 AM
carumuga carumuga is offline
Authorized User
 
Join Date: Dec 2006
Location: chennai, tn, India.
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSIS - Flat file to OLEDB Destination

Hi,

I have the flat file with the data
01.08.2008,xyz,yyy
01.08.2008,xyz,yyy

which 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.



Thanks,
Chandra
__________________
Thanks,
Chandra