May 13, 2010 at 12:16 pm
I have a pretty simple SSIS package that exports the contents of a table to an Excel spreadsheet using an Excel Destination connection. Some of the columns are decimal so I created a formatted template and use a File System Task to copy the template into place prior to exporting. In the template I put in the column headers and bolded them. All rows exported to the .xls are then bolded, even though rows 2+ are not bolded in the template. If I remove the bolding then all rows are in plain text. The decimal formatting works fine. Am I doing something wrong? I would think this is being done all over the place.
In DTS I would do this with an ActiveX Script Task. There I would create the Excel object and format columns to my heart's content. But there I had Excel installed on the SQL Server. Here I don't have Excel installed. Figured I didn't need it with the Excel Connection.
Thanks everyone.
May 13, 2010 at 12:52 pm
Using the excel destination you can not control the format. you do not need Excel installed on teh destination however if you do happen to have it installed or if that is not an issue for you to install it then you can use a VB script to do the same thing you used to do with the active x script. Using the excel destination though is less then intuitive and I know from my own perspective we have encountered many problems with how it may get exported.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply