Hi,

Could you please provide your sample update query here. How you use the single quote in your query needs to be checked.

For this error, as other empirical solutions: you might as well try the below options:

1.This error may also crop up if there are NULL values in the dimension attributes. Delete...

Jeff and Dev,

It was intended to present one more possible way 😛 . You got that right, with just 400K rows, it might be calling for more efforts. My bad...

Hi Md.Noorullah,

What is the issue you are facing? Processing FULL should work anyways.

If your requirement is to insert all those rows at a time into the concerned table, you might as well try using the BULK INSERT command.

First, BCP out the...

There's the SQL Server "tablediff" utility as well; if it fits your requirements.

I had similar issue with a measure group partition. This refers to the 'source' property of the partition which can be and can be set to proper source table/view.

Hi,

First Process Update the concerned dimension. After this is done, PROCESS FULL the concerned measure group individually. Faced this issue several times, and this fix always works.

Resolved the issue. The data type of the joining column between dimension base table and measure group base fact table, had difference in data type with INT in dim base...

1. Which component to use ?

Control Flow component called "Send Email Task" OR if we are too enamored with scripts stored procedure sp_send_dbmail is also an option.

2. How to...

It would help you if you could post zombie DDLs for your tables. Here it seems that the input table does not contain the UserID. So if you need to...

So what are the values that go into each of the two columns of your website table i.e how do you decide what part of this single column goes into...

Got that. Thank you Lutz and Drew. 🙂

Drew,

It appears in this case NumberOfUsers having DISTINCT COUNT Aggregation function cannot be aggregated along any dimension (going by the BOL definition) . I am more inclined to then consider...

Also, you might as well save time, your and others as well, using google 😀 for the insert syntax rather than ask for such basics answer here and wait for...