select

CASE WHEN NULLIF('B',NULL) ...

Just double checked and looks like a suitable option.

Cheers

E

Eugene Elutin (5/24/2013)

You can wrap...

Had looked at ISNULL and it seemed the obvious easy choice. However from my understanding there are two pitfalls.

1. If you choose a valid replcaement for null such as Zero...

I would prefer a separate staging table for each of the different versions of customer.

Then I would look ate combined table with the conformed customer dimension.

I would use merge to...

Well we are about half way there.

Got SQL Server Database Engine up and running. I was expecting SSAS and SSIS to be available via SSMS.

However when I go to connect...

Error Logs

2013-05-15 20:58:54.04 spid13s Error: 17182, Severity: 16, State: 1.

2013-05-15 20:58:54.04 spid13s TDSSNIClient initialization failed with error 0x271d, status code 0xa. Reason:...

yes.

Also unless I am mistaken there is the two lines

set @start_lsn = sys.fn_cdc_hexstrtobin(@start_lsn_str)

set @end_lsn = sys.fn_cdc_hexstrtobin(@end_lsn_str)

that are not utilised.

I have repeatedly altered the code...

Had not thought of that. However that will require me writing 30+ stored Procedures as well as the packages. Experimenting with dynamic code inside the Execute Sql Task that may...

Any suggestions?

Thanks

M

After googling substantially before hand I stumbled across a blog linked to a codeplex sample. Trawling thorough that I got to

EXECUTE SQL TAsk contains:

declare

@startLSN binary(10),

@startLSN_str nvarchar(42)

select @startLSN...

Not on a corporate machine. I have a clean windows 8 laptop. I have had several attempts at this and we still can't seem to move forward.

Think there is an...

This location documents the processing options for Analysis Services objects. Have a good read through and see what will work for you. If it is historical data how regularly are...

What is the database that you are looking at. If SQL Server then possibly CDC(change data capture) could be of interest? That would identify the changes.

Then process update could...

VeeKay (2/15/2013)

I'm running into a similar situation. Can you please provide some direction/example of the methods to create a DIMENSION from the column in the FACT table? E.g. I'm having...