I don't want to promote dental problems, so

I think I'm known in the neighborhood as the "Popcorn Lady".

I give one serving sized microwave popcorn & the kids always...

I too work in the Financial industry, in an MIS department. We are swamped with the reporting needs for management & models being rewritten as Steve eluded to. ...

You may want to check into using SQl triggers - -

I believe they give you the ability to determine how to resolve

the situation of 2 users both having...

WOW ! What a detailed response!

I'm looking forward to giving this a go.

I'll be back with questions if I run in to problems.

Thanx much for the reply !

Beth

Vika:

Did you copy/paste from ActiveX or did you need to rewrite?

How long did it tak eyou to convert it?

Thanx.

Beth

I, too, am getting the same error as I try to execute my first SSIS package.

All I did was copy & paste the ActiveX from the DTS to an ActiveX...

Thanx - I guess I've got to get used to the changes...

I liked how it was grouped by articles, scripts & forums.

I mkae it look pretty in BIDS, do an <Alt><Print Screen> and paste it into WordPad.  I usually change it to landscape & then print.

Beth

Loner:

If you don't mind me asking, where in the US are you located ?  I'm in WI. 

I've "been there, done that" re: many of the issues you've bought up and thought...

I found the MS tutorials very helpful & good place to start. 

Here are some links to forums I use as I also learn this stuff:

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.olap&lang=en&cr=US

http://groups.google.com/group/microsoft.public.sqlserver.olap/topics

http://www.tek-tips.com/threadminder.cfm?pid=960

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

http://forums.databasejournal.com/forumdisplay.php?f=2

I just tested one of them and it runs correctly now.

Yesterday when I ran a different one, it did not run in the workflow sequence.  It didn't start with the correct task.(That's why...

I finally got it to work!

Thanx netmikem & NPeeters - it turned out to be a combo of both suggestions.

I wrote inserted to another table and found one of the...

I tried that and it still didn't help the problem.

It does whichever UPDATE comes first in the trigger successfully (I've swapped the two around and know it's not the syntax...

Nope, there is no trigger on the IM_SUBITEM table. There has got to be a way to have it continue on to the second UPDATE statement - I'm just...

It seems that no matter which order the two UPDATE statements are in, the first one is the only one that fires. Am I missing some key word to...