SSIS And Sapce in EXCEL Tab Names

Question

SSIS And Sapce in EXCEL Tab Names

Mike Carlson

SSC Journeyman

Points: 85
More actions
February 1, 2010 at 1:21 pm

#216066

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?

Viewing 4 posts - 1 through 4 (of 4 total)

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

WayneS SSC Guru Points: 95461 More actions · Answer 1

You are actually creating a tab and a named range. Since the named range cannot have spaces, any are converted to underscores.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Mike Carlson SSC Journeyman Points: 85 More actions · Answer 2

Thanks for the tip! How do I fix this? I just need a tab named Data Format and the first row to be the column names I specify in the query.

Mike Carlson SSC Journeyman Points: 85 More actions · Answer 3

Bump.... any ideas on this one?

Here is a snippet of the SQL code that SSIS used to create the new sheet in the work book:

CREATE TABLE `Data Format` (

`Item ID` LongText,

`Action Flag` LongText,

`Sale End Date` LongText,

`Low Inventory alert` LongText,

`Feature Image URL #1` LongText,

)

GO

You can also see how its trying to name the column with the "#" sign but it gets replaced with a "." when I check "first row has column names".