BI – SSIS


SSAS Cube with MDX

SSIS package a few months back to retrieve data from a SSAS cube with MDX queries. The data flow was lost somewhere and the package could never finish the data loading. This is what it will look like in the Data Flow task. The OLE DB Source will stay yellow forever.

mdx

SSIS package was configured to make the data flow work. I had to find my old SSIS package and open it to refresh my memory.  After choosing the OLE DB Provider for Analysis Services 10.0 as the provider for the connection manager, we need to go to the All tab to set Format=Tabular in the Data Link Extended Properties.
Need to set Format=Tabular in the Data Link Extended Properties.

ole db

Green color is what you will see once you set Format=Tabular in the Data Link Extended Properties.

 

Back to top

ole db desti

SSIS that data type DT_WSTR (nvarchar) will be used instead

wstr

Data Conversion transformation to convert the DT_WSTR to DT_STR or DT_NUMERIC accordingly.

 

SQL – Structured Query Language. Here is the Transact-SQL Reference (Database Engine).

 

Back to top

Advertisements

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