SSIS: Cube data source data types conversion – derived column expression

Scenario:

I had a OLE DB data source for SSAS using query. It was returning the column names like [Time].[Reporting Period].[Fiscal Year].[Member_CAPTION]

When I tried to convert the data types using the derived column type cast – DT_WSTR(expression, size), it was returning error: cannot parse the expression. The expression was not valid.

c1

 

Solution:

The reason it was returning error because of the column name format  [Time].[Reporting Period].[FiscalYear].[Member_CAPTION]. So I went to OLE DB data source properties–>column tab and then rename the output columns without the [] and like “Fiscal Year”. After that it started working.

c2

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