That's not...

Could it be a problem with spaces in the column names?

I had to do something very similar recently. Check this thread for a fast T-SQL solution (and many other interesting suggestions!)

Hi Jason

This stuff is much easier to read if you use code="sql" tags (+ thanks to SQL Prompt for reformatting):

declare @ServerName as varchar(60)

set @servername = 'yourservernamehere'

create table TEMPDB.dbo.tFreeSpace

(

...

In the absence of a question in your post, it seems that the import/export (or should that be export/import) method is the one to use.

True for 2003. 2007 onwards allow 16,384 columns, requiring a truly microscopic font in SSRS 😛

Good answer, but note that you have answered a question which is more than a year old 🙂

What do you mean by 'remote'? Outside of your LAN?

And, especially around the middle of the afternoon, or when you accidentally pressed F5 while connected to production, DUMP.

I'm still a little puzzled.

I create a new Excel Workbook from scratch.

I import the Pivot Tables into 7 different sheets and the size grows to 116MB even though I deleted...

Welsh Corgi (11/7/2011)

---

I'm loading multiple Sheets into an Excel File from SQL Server.

The macro listed below will reset the used cell ranges and should reduce the File Size.

I can't...

Perhaps this thread is of interest.

Script component is what you mean, I think.

Well done on taking the time to find a solution to your problem.

I still have concerns over the potential performance of your...

Don't think so. But you can use a combination of SUBSTRING and RIGHT to achieve the same thing - something like this (untested):

UPPER(SUBSTRING(@FileName,1,11))=="NEWPRODUCTS" && UPPER(RIGHT(@FileName,3))=="TXT"

I can't see any reason why this would help in this case, but I have generally had more success using UNC paths rather than mapped drives for jobs like this.