December 11, 2009 at 12:36 pm
I have a simple SSIS package that reads all rows of 2 database views into an Excel speadsheets. It works quite well except for a couple of quirky things. (The spreadsheets are sent to an outside business partner with very strict formatting requirements which are not quite being met as yet. )
There are a number of columns in the views with names containing a number sign (#). In the spreadsheets, all number signs in column headings are showing up as periods (.)
The SSIS flow is as follows
1. The prvious sheet is deleted - no issues
2. A new sheet is created - with column headings
3. the data is tranfered to the spreadsheet from the database. - no isues
This is the create table statement that produces one of the spreadsheets as in 2 above. The problem column name is `SIN, SSN or TAX ID #` :
CREATE TABLE `StockOptions` (
`Last Name` NVARCHAR(30),
`First Name` NVARCHAR(30),
`Middle Name` NVARCHAR(30),
`Address 1` NVARCHAR(30),
`Address 2` NVARCHAR(30),
`Address 3` NVARCHAR(30),
`City` NVARCHAR(30),
`State/Province` NVARCHAR(30),
`Zip/Postal` NVARCHAR(30),
`Country` NVARCHAR(30),
`Preferred Language` NVARCHAR(30),
`SIN, SSN or TAX ID #` NVARCHAR(30),
`Home Phone` NVARCHAR(30),
`Business Phone` NVARCHAR(30),
`Email Address` NVARCHAR(200),
`Bank Institution Name` NVARCHAR(30),
`Bank Institution Number` NVARCHAR(30),
`Bank Account Number` NVARCHAR(30),
`Bank Account Currency` NVARCHAR(30),
`Employee ID` NVARCHAR(30),
`Hire Date` DATETIME,
`Employment Status Action` NVARCHAR(30),
`Employment Status Reason` NVARCHAR(30),
`Employment Status Effective Date` DATETIME,
`Payroll Center` NVARCHAR(30),
`Employment Position` NVARCHAR(30)
)
Please help if you can. I am stumped at this point.
December 11, 2009 at 1:08 pm
[font="Comic Sans MS"]
Hi Norm,
1) Which version of excel are you using?
2) Which Excel connection manager are you using?
--
Also out of curiosity you please explain how are you doing these:
1. The previous sheet is deleted - no issues
2. A new sheet is created - with column headings
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply