Home > SSIS > Dynamic Connection String Settings in SSIS to Connect SSAS Cube, Should not have Invalid values

Dynamic Connection String Settings in SSIS to Connect SSAS Cube, Should not have Invalid values

Recently we have found one strange behavior while Processing SSAS cube using SSIS -Analysis Services Processing Task.

We have Dynamic connection string to connect the SSAS cube in SSIS package. Cube Database name we have given dynamically.

If Cube Database name is invalid one in the variable, and we setting this variable before connecting Cube to process the cube, still it throws the error.

However when we put the variable blank (no invalid name). Then it executes successfully.

If we connect the SQL database with above scenario we will not get any error , Only for SSAS its throws error.

Let’s check what we are mentioned above.

Create One SSIS package, create two variables one for SSAS cube database and another for SQL Database as shown below:-

Variables

Note Above two variables we have given invalid value.

Lets create Two Execute SQL task which will set the correct values of DB Name to respective variables.

After below those two Execute SQL task we will test the connection string as shown in below screen.

Structure To Test ConnectionString

Lets execute the package with wrong Names of DB , it will show below screen.

SSASFalied

So SSAS got failed, if you notice we have set the correct value before SSAS process task execute.

Let’s try with blank values.

SSAS with Blank Value

Now with blank values its working.

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: SSIS Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: