That's called a "Running Total". See the following URL for one of the better ways to do that.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

I'm no DTS or SSIS "Ninja", so I can't help there. What I have done is create another spreadsheet that would open the others and export their data to...

Eric,

What is it that you intend to do with the VBA?

Heh... if you're happy with 4 hours, I'm happy. 🙂

You're looking at the code that SQL Server generated to run some user code... better if you look at the user code. Look for long transactions to begin with...

Just a side bar... if the job is taking 4 hours on anything to run, you might want to look at tuning the code instead of trying to tune SSIS....

Heh... cgnospam words are pretty strong and most folks who have an MVP would certainly be upset about being called a "marketing whore" or maybe even an "evangelist" :hehe:, but...

You already said that... this is the third time... relax... someone else will answer...

It's just me, but I'd forget about spending any further time on that... it's time to start looking at the code and fixing it. You already know that they...

Eric,

You're a good man... you came on board with a question that, obviously, no one else is able to answer and you continue to post your findings. All I...

You'll find that double posting within a thread will piss people off worse than normal double posting. 😉

That was the recommendation I made above... so, Yes.

It was at least that long ago for me as well... and I could also have a failing memory ...

I guess the good thing is... we don't have to...

Uh huh... are those the same executives that think "Bananas in Pajamas" is an appropriate title for a kids' show? :hehe:

Loner (7/12/2008)

---

The second one was I had to build a data warehouse. I would get data from different outside sources. Each one would give me a text delimited file...