Post reply

How to give font colour in excel sheet using ssis?

  • February 23, 2009 at 12:45 am

    #134934

    How to give font color for the first row of excel sheet when we export the datas from sql server database to excel sheet destination?

    Thanks in advance

  • July 22, 2010 at 6:48 am

    #1196809

    I have a similar problem. I have to colour the cells in excel using SSIS. Any solution for this?

  • July 22, 2010 at 8:10 am

    #1196870

    I have not done this, but I would imagine you would use a Script Task and the Excel Object Model to manipulate the font color of cells.

    You would have to install the Microsoft Office Primary Interop Assemblies and set a reference to the Microsoft Excel Object Library in the Script Task.

    I don't know how robust this is for server-side processes. Generally I have seen advice against instantiating Excel objects on a server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply