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...

It seems that you are not the first to come across this problem. Take a look here and see whether it might be relevant.

Jeff Moden (11/11/2011)

---

Gosh... I went back and looked at one of the links for SQL Server questions and answers. Part of the reason that I recommend NOT using such...

Not sure I understand. How is this related to SSIS?

Note to OP: sorry for hijacking your thread 🙂

Morocco is hectic and chaotic. An interesting place, with some excellent people and many more who are just trying to separate me...

Koen Verbeeck (11/10/2011)

---

Phil Parkin (11/10/2011)

---

kramaswamy (11/8/2011)

---

IF there isn't a huge amount of logic being used to transfer the data, maybe you could use a foreach loop, and have a table...