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.
| Author |
Topic |
|
Harvey85
Starting Member
4 Posts |
 Posted - 2011-11-16 : 16:26:44
|
| Hi,Actually , I have a situation , I want my Excel destination file to look fancy in a manner that the first row should be Bold, having different colors, also having the Filters attached to it, and i also have to freeze the columns too. Here I am using the ssis Package in which , i am using One Master Template, therefore , if i do any formatting in Master Template , It should also be appended to my Main Excel Destination file. But My package Fails here due to any of the changes I made in formatting. Oherwise , If i didn't make any changes , Packages runs Fine.Even there is also a compatibilty Issue with Excel File(If any changes made) as the Excel File created through ssis is 2003 version and I have 2010 version installed on my computer Error in SSIS:SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21Cannot create an OLE DB accessor. Verify that the column metadata is valid.Any Help will be appreciated Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-16 : 19:42:39
|
| Pump the raw data to sheet2 and do the formatting and display on sheet1. |
 |
|
|
|
|
|
|
|
Problem In Excel Destination, If we any Formatting