Discussion:
SSIS Export Excel Space Tab Name And More
(too old to reply)
DomitianX
2010-02-01 20:17:56 UTC
Permalink
I am running into an issue that no matter how I format the Prepare SQL
task, it puts a "_" in the tab name.

CREATE TABLE `Data Format`

Show up as Data_Format in Excel. This is for an automated process and
the space cannot be there.

Also, it its replacing my "#" for column names with "."s

`Feature Image URL #1` LongText,

Shows up as

Feature Image URL .1 in Excel

Any idea how to format this properly?
Todd C
2010-02-02 13:38:01 UTC
Permalink
Have you tried square brackets in the names?

CREATE TABLE [Data Format]
?
HTH
--
Todd C
MCTS SQL Server 2005
Post by DomitianX
I am running into an issue that no matter how I format the Prepare SQL
task, it puts a "_" in the tab name.
CREATE TABLE `Data Format`
Show up as Data_Format in Excel. This is for an automated process and
the space cannot be there.
Also, it its replacing my "#" for column names with "."s
`Feature Image URL #1` LongText,
Shows up as
Feature Image URL .1 in Excel
Any idea how to format this properly?
.
Loading...