Brandie Tarvin (10/27/2015)

---

Koen Verbeeck (10/27/2015)

---

So the source database of the ERP system is on server A. I can't touch that one, not even read from it (yeah don't get me...

Brandie Tarvin (10/27/2015)

---

So Server A has database ABC. Server B has database DEF. You need some of the data from DEF to be in ABC? Or is it just copied...

SimonH (10/27/2015)

---

Could you not use a cached Lookup on the IDs, as opposed to a Merge Join

and then use an SSIS script (gives you access to C# hashbytes function which...

SimonH (10/27/2015)

---

Jayanth and Eirikur: your delta proposals seem quite interesting.

How did you create the delta?

Using the EXCEPT operator? This might be quite slow on the larger tables (about 10 million...

I'm thinking a left join between the recent table and the old table. There are no deletes and with a left join I have all the inserts.

Using hashes, I can...

Also keep in mind that sometimes SSAS displays its most crucial error information in warnings, instead of actual errors.

Jayanth and Eirikur: your delta proposals seem quite interesting.

How did you create the delta?

Using the EXCEPT operator? This might be quite slow on the larger tables (about 10 million rows).

I need a subset.

But the tables I need are still quite large (let's say in total 20GB).

There's...

It's all in the same company, but in different locations.

So again, the network is too slow to send a copy. (and it has to be automated daily)

It takes 17 hours...

Any assistance on this problem is greatly appreciated:

http://www.sqlservercentral.com/Forums/Topic1731087-3411-1.aspx

It's a bit out of my league as a BI guy 🙂

Great question, thanks.

Nice one, thanks.

Easy one, thanks.

Interesting question, thanks.

Easy one, thanks.