There is a ProtectionLevel property on your package to determine how usernames and passwords are encrypted. By default, only the NT login that created a package can decrypt sensitive...

The error you have posted is because you left the default setting for the ProtectionLevel property of your package set to EncryptSensitiveWithUserKey. This basically means that only the NT...

I have to assume you have something directed to the wrong table, a bad join, or something else preventing the cube from getting your new data.

An index is not going to help you because your criteria begins with a wildcard. So, the query needs to evaluate for every row regardless of an index existing.

In...

A derived column is within SSIS only. If you want to add the column to your table, you have to go to the table, add the column, and then...

I have paid less.

Just buy it from a reputable software vendor and not CheapSoftware999 on ebay and you should be ok.

Ignore the "First" fields when you set up the SCD wizard. Allow the wizard to set them to NULL when it inserts a record and have it do nothing...

Still haven't had that coffee, huh?

The alias is a good idea though.

Yes, that's the only way you can connect, but the delimiter you use can be changed before making the call.

So you are letting the user choose from a list of servers. Your list of servers has ServerName,PortNumber and this is what you are passing.

Why not change this list...

Do a "Process Update" on any related dimensions that have had data changes.

Do a "Process Data" on the individual partition for the measure group you have added data to.

Do a...

Ok, it's not tested, but it would be something like this:

[font="Courier New"]CREATE PROCEDURE dbo.spWaitForProcess

@intvlsec INT

, @timeoutsec INT

AS

DECLARE @totalsec INT

, @delay VARCHAR(14)

SET @totalsec = 0

SET @delay = CONVERT(VARCHAR,DATEADD(Second,@intvlsec,0),114)

/* Modify select statement...

You can have a lot of logins, so it would not be bad to use the structure that is there.

There are some real benefits to using a login per-user rather...

In your situation, it would probably be best to simply check the server name in your loop and if it is the local server, execute it locally instead of using...

To start with, turn on package logging to see where exactly it is getting stuck. BIDS is 32 bit, so you may be having a problem with the job...