Talk to your BI department and try to convince them to build an actual solution worthy of the name BI. 😉

I think this thread sums up the general feeling towards code formatting displayed in this thread.

http://www.sqlservercentral.com/Forums/Topic1577630-391-1.aspx

There is soap behind the counter to wash your eyes with...

Please, can you put a little effort in formatting your code?

This is really awful to read.

Anyway, you probably will need some dynamic SQL to select the columns needed from the...

+2

Thanks for the question.

Jeff Moden (6/4/2014)

---

Koen Verbeeck (6/4/2014)

---

SQLRNNR (6/4/2014)

---

Evil Kraig F (6/3/2014)

---

SSIS: Crappy naming methods for your data sources. You're connecting this thing to a database and you're going to push it...

Well,...

Grant Fritchey (6/4/2014)

---

As far as licensing goes, to my knowledge, all these tools are freely available, depending on what licenses you have. If you have a Visual Studio license, you...

You could try the following:

use a case statement. Do a count over the partition (just like you did with the row_number() function).

If the count is 1, do nothing. If the...

Is it possible to have some screenshot to clarify your issue?

Every time you load facts into the fact table, you do a lookup to the product dimension using the product business key.

You simply retrieve all the current records (meaning the...

viresh29 (6/4/2014)

---

Yes It will convert it to 0. But I had the same issue and I used derive column with above expression and converted empty space into NULL and then...

+1. It should not matter where the data comes from, as...

An easy trick is to have an empty excel file somewhere.

Each time you enter the loop, you copy the file to the directory you want it to be and you...

I had the same issue once. Not sure if I resolved it back then 🙂

Take a look at this thread:

http://dbaspot.com/sqlserver-faq/230577-ms-sql-server-management-studio-import-export-settings.html

Personally I would just include a field in the dimension that stores the source where the record came from.

Is it possible though the dimension info for one record can come...