Nice question, thanks.

When you run the SQL Server set-up, SQL Server Data Tools is mentioned in the list of features you can install. That is the one you need for VS2010.

According to a comment from MSFT on this blog post, they started a project to make...

ps_vbdev (5/29/2014)

---

Thanks Koen

How do you know what and when something should be in the dim tables or fact, this is what im find hard as just starting in DW,...

Call me weird, but why don't you just use the already existing SSRS instance?

Personally I believe it is your chance to do things right, so I would create a PK (as a clustered index).

ps_vbdev (5/27/2014)

---

So the designers prices and surcharges would go in the product dimension as they are fixed im sure when the product is created. But would pull the the retailers...

Strix (5/28/2014)

---

I found the cause.

On the SQL server where the job was created, IS was not installed.

The dtexec executable is present, but it seems you have to install the complete...

Very nice question, thanks.

Never used the function before though.

Glad you found a solution. Thanks for posting back.

There is SQL Server Data Tools (SSDT) for database projects, and SSDT for BI projects.

Two different products, but with the same name (mostly).

With the first one, you cannot edit SSIS...

What is the data type of that column? You can check this in the advanced editor of the source.

vanamali (5/27/2014)

---

Hi,

Thank you very much for the response. I came to know that we can not set the Package Variables' in 'SSISDB 2012 project deployment' for...

momer79 (5/26/2014)

---

Koen Verbeeck (5/26/2014)

---

momer79 (5/26/2014)

---

SQL Server 2008 R2 exam is still valid and it is not going expire in near future.

One exam would give you MCTS and it will never...

Yes.