Just don't give it the finger 🙂

I did not mind the question at all. Thank you for the contribution.

Sweat that one out. I must stop thinking everyone is out to trick me!

Have the appropriate rights been granted in SSISDB and at the Project/Folder level for the linked server account?

Have the appropriate rights been granted in SSISDB and at the Project/Folder level for the linked server account?

There are also other internal bitmap indexes in the various file structures containing dimension data, but these are not indexes that you typically create declaratively with DDL like in an...

By default SSAS roles are not granted cube access. You must explicity grant privileges to that role you created. Have you done that yet?

As a rule, when you've gone past 15 dimensions in most solutions, chances are there are some opportunities for the consolidation of dimensions. I have never personally had a solution...

Additionally, I tend to go with one package per target table loaded--with rare exceptions.

What happens if you try to execute T-SQL stored procedures remotely with T-SQL?

EXEC [SSISDB].[catalog].[create_execution]

EXEC [SSISDB].[catalog].[set_execution_parameter_value]

EXEC [SSISDB].[catalog].[start_execution]

It is important to note that:

SNOMED more facilitates information input into an electronic record during patient care (OLTP in concept)

Conversly, ICD facilitates data retrieval for purposes outside of patient care...

You almost got me!

Time series allows for drillthrough, but AFAIK it is only allowed when using DMX. Last time I used Time Series, the designer did not...

I was hoping for some sleazy hack besides those 2 options..... 😎

I have a personal preference (if possible) for remoting into a dev server that has BIDS installed so that my machine does not get crippled.

Koen/Kraig,

Is this type of external metadata...

+1

No clue as to why VS would hang. How much memory is on the Visual Studio host? Does the package execute when calling it from DTEXEC.exe or from...

Your final decision sounds like the appropriate one. As you may know, sometimes a table can act as both a fact and dimension. It all depends upon the business questions...