Paul - THANK YOU for this * 100000000000000000000

thank you thank you thank you.

And yes I read the whole article, and sent on to my jr. dba. 😉

I would really like to be able to use the OLEDB for DB2 driver on a Standard box.

I should have thought of that.

Will try.

Thanks!!!

We did. I put a little dbmail hack in between the steps so I could get the time each item began and ended.

I reckon that's the best I am...

Well, it isnt run from a SQL Agent job. Hence the problem.

Oh well...

I am a data warehouse architect and one company I worked for tried to force me to use Visio . I threw a fit (so to speak) and did...

I have run into the same type of scenario, and I do

use the Union All task.

The only trouble I find with it is when I need to modifiy

anything...

you are correct. they do not need visual studio or BIDS.

the one-click will install the Report Builder on their machine.

best of luck!

For what its worth...

While I despise excel more than anything else in

creation, I have finally accepted that a)users like it,

and b)they already know how to use it, and more...

I do something a bit different.

The first combo box I popuolate with "Elployee", "Dept" and so on....

in other words "user - how do you want to filter?"

then based upon what...

true, but no mountians in Raleigh. lol.

A guy back home in FL used to walk down US41 playing one...

I was very inspired.

I play piano (classical) and violin.

My dream is to learn the bagpipes....

but where to practice ? 🙂

For what its worth...

Those of you who are new to SSIS...

It will get better! You'll discover the weird little things about

SSIS and yes, you will pull out your...

Ahh yes, I have been there.

What I do is similar to this:

lets say my parms are like this:

FilterCategory1 (they pick the word Customer, Account, Division, etc)

FilterValue1 (popultaes based on what...

Not sure if this will help, but...

One way I have used for a few years now is to create

a set up parameters that the user can control HOW they filter.

I.e....