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?

Have you tried square brackets in the names?

CREATE TABLE [Data Format]
?
HTH
--
Todd C
MCTS SQL Server 2005


"DomitianX" wrote: