Hi,

during an analysis about setting up connections from Business Objects to MSAS I came across the following links helping me to get a clearer picture about security and autjorization.

http://support.microsoft.com/kb/828280/en-us

Concerning...

Hi,

you can simply add the new column manually in the connection manager (in the "advanced" section right below "columns") and define its data type and size.

You can then place the...

Hi,

judging from your error message I would assume that your package already fails gathering the necessary information about the logins to transfer.

Did you try and set a default database for...

Hi,

you need to set up a connection using the OLAP client, not ODBC.

You may have to install the connection related files before you will be able to see AS.

You may...

Hi,

I think you do not need to do anything in MDX with your example.

Once you can calculate the first ratio on the lowest level of granularity, you only need to...

Hi,

did you think about storing your data in a star schema with columns and rows as dimensions adding a date dimension to allow you to identify the data belonging to...

I suppose you tried to set the "max ... commit size" property in the advanced editor of your data destination.

Sorry, but I cannot check whether this is available for non...

Hi,

this depends on your client and what method it will use.

I assume that you should be able to install all necessary connectivity if you simply install the workstation components without...

Hi,

you can use the same technique to define a variable to hold the path value.

Inside your SSIS package you need to use an expression for the path property of your...

Hi Pat,

if i remember correctly the values are read in and applied at runtime only.

This implies that depending on your use of the values, you may not see them when...

Hi,

I would try a derived column transformation in your case.

Michael

Hi,

in the next screen you see my simple example.

You need to first connect the Flat File destination to the previous...

Hi,

from your description I cannot say that you are wrong.

I have included a screenshot of how I would set up the flat file connection manager to achieve what I understood...

Hi,

now you need to return to the BIDS part of previous posts.

I do not know of any other way to edit packages.

There are a nuimber of reasons to save...

Hi,

are you sure you always took care to close all your database connections you opened in eth application?

I remember seeing similar effects in one off my projects when some were...