Good guess Simon .

Doing this from memory, Simon is right. The correct type is SQL_PARAM_OUTPUT. Just check SQLBindParam in the MSDN for more information.

The first thing that comes to mind is the user the SQL Agent service is running with. Your DTS package (when scheduled as a job), will run under that NT...

Use a calculated member. If your geographical hierarchy is called 'Location', you would need to add the following MDX expression.

 ([Location].CurrentMember, Measures.[Sales]) / ([Location].CurrentMember.Parent, Measures.[Sales])...

Can you give us more information on how your database is organised?

I do not think the user needs any specific security rights to run the package, unless you have specified a package password. He just has to have access to the...

I think the best approach is to store the result of the function fMStdDev in a temporary table (along with the primary key of the table). In a second phase...

Follow this link. It points to a piece of Perl code that allows you to look through a bunch of files for one or more 'patterns'.

http://www.mts.net/~pb999874/perl/pgreppl.txt

I certainly don't know such a program, but I might have some ideas how to solve this problem.

They both boil down to having (i) some search criterium and (ii) having...

I'm not entirely sure how you are setting up the DTS package, but I don't think you can do what you want in a simple step.

First of all, you will...

Had the same problem before. And as I remember, you should update your SQL Server installation as is mentioned in the Microsoft KB. Worked like a charm for us.

I haven't...

If it really is the SQL Service that is no longer starting up, you should check the account that is used by the service.

So, go to Control Panel->Administrative tools->Services.

You will...

Like the XML idea by the way.

If you ever have a framework that you would like to share with us

Great to be of (some) help. But I would like to comment on your last post.

In my opinion you are mixing up two different things. First is commenting the code...

I try to enforce a scheme like that of David. Developpers always argue that it is a lot of work, filling up all the fields. (They obviously have never had...

Is it possible that you have mixed mode authentication enabled?

In that case, SQL Server might let you in, based on the 'trusted' connection from your windows session.

The easiest test is...