Hi! In the template Excel sheet I formatted the 2 nd row to display the dollar sign and made it into a hidden row. But the output file does not show the dollar sign. Any suggestions to rectify this. I tried to create an empty table as suggested on Excel connection but that scenario did not work, Another route that I tried was through the script task wb.Worksheets("Test").Columns("D:D").NumberFormat = "$#,##0.00" This is not displaying the dollar sign -- Any suggestions on what I am missing? Thanks
I am sure it cant be as easy as I am thinking. Assumption - source column is money and has values say 1.00, 3.00, 800.232 and we want output in excel sheet as $1.00, $3.00, $800.23 Solution - Step1. create oledb source that would get data from sp Step2. add derived column, add a new column (say it is new_col) and with following expression:- "$" + (DT_STR,10,1252)((DT_DECIMAL,2)i) Step3. Bind the new_column to the corresponding column in excel.