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.

No problem!

Hehe.

Here's how it's done in SSIS.

1) Add a data flow task.

2) Add an OLEDB source connection to the DF.

3) In the connection manager settings for the OLEDB source, select 'SQL...

Thanks for the extra detail - makes more sense now.

If you want to avoid loops, you'll need to use the power of the database - and as the data is...

I'll start off by saying that I am almost certain that no WHILE loop will be required here.

But in order to get to a solution, I'll need to ask a...