July 27, 2010 at 2:25 pm
Hello,
I have a straightforward package that uses an OLEDB Source to copy data using a query to a Flat File Connection Destination (.csv). The date field is not displaying properly when I open the .csv destination file. In the OLE DB Source the date DATA TYPE is a DATETIME and on the .csv Destination file it displays as 43:33.3. The Flat File Destination Manager Editor shows it as a DATATIME STAMP on the Columns Page. Has anyone see this before?
Thanks,
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
July 27, 2010 at 3:27 pm
MostInterestingMan (7/27/2010)
Hello,I have a straightforward package that uses an OLEDB Source to copy data using a query to a Flat File Connection Destination (.csv). The date field is not displaying properly when I open the .csv destination file. In the OLE DB Source the date DATA TYPE is a DATETIME and on the .csv Destination file it displays as 43:33.3. The Flat File Destination Manager Editor shows it as a DATATIME STAMP on the Columns Page. Has anyone see this before?
Thanks,
Yes. I have seen this before. We can either format the excel sheet column to display it in date format or we need to use the "data conversion" task to convert the format to date format and then load it in target .csv file.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply