February 14, 2008 at 1:41 pm
Essentially I first noticed the issue in SSIS I am writing to an EXCEL Destination and I have a couple of column headers with special characters (but not really that special) '#'. However in the export the '#' (pound) becomes a '.' (period) in all the headers that it showed up. I thought it was odd so I tried to reproduce a similar situation in SQLManager using the Task-> export. And then just used Select 1 as [# Stuff], with Excel 2003 as the destination. I received the exact same character conversion the pounds had become periods.
Any suggestions or comments with regard to this would be greatly appreciated.
September 19, 2008 at 10:50 am
Were you able to resolve this issue. I'm having the same problem. Anybody have any suggestions?
Thanks.
September 19, 2008 at 11:45 am
no unfortunately after a great deal of time with Microsoft they said it was bug and there wasn't much I could do about. It has to do with those being reserved characters I believe in Excel.
What I did to get around it was I created a small helper app that runs with the package in an Execute process task that goes in and changes the characters to what they need to be. Its not a terribly robust solution but it was simple enough to handle this particular problem. And that is about the only way I know around it.
September 19, 2008 at 2:14 pm
thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply