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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Problem with showing .00 as 0.00

Author  Topic 

Shubhanshu
Starting Member

8 Posts

Posted - 2014-09-15 : 10:27:35
Hi
I am exporting data from sql server to Excel. I have one column which has decimal values. But for 0.00 it is showing as .00?

I have tried using derived column with Decimal datatype but no success

Please let me know if someone has any solution for it.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-15 : 10:33:41
Do your formatting in Excel, not in SSIS
Go to Top of Page
   

- Advertisement -