Why? You already have CLR 😛

Easy one, thanks.

Did you install SSRS in native mode or in SharePoint integrated mode?

During set-up, did you choose for installation and configure, or for installation only?

Since SSRS 2008, you don't need IIS...

karen.ferrara (9/21/2016)

---

I tried another approach to my deployment today. I connected to Integration Services from SSMS and then used the import package feature there to import the package. ...

I noticed you can now access on-premise data as well using the data management gateway, so maybe I was a bit too quick to say there's...

ps_vbdev (9/21/2016)

---

Great i must be progressing as this was what i was thinking :-). My only reservation on adding a DimRole to the model was because the FactOrder grain is...

Definitely not a junk dimension, but rather a role dimension as John suggests.

You could add attributes to the customer dimension signifying which roles they have already played. For examle: HasBeenGroom,...

There's no real SSIS as a service in Azure.

You can host a machine in Azure though and install SSIS on it, just like on any regular virtual machine.

I'd start with a SELECT DISTINCT on the staging table.

How do your reference tables look like?

Can you give some sample data?

Interesting question, thanks.

Sad to see spam is still an issue here.

I don't have Tabular installed on my laptop, so I can't test right now.

Is it possible to post some screenshots?

Thanks for the question.

You forgot a part of the update statement.

UPDATE d

set [Description] = Replace(d.Description, d.Description ,(c.zipcode + ' - ' + d.Description) )

FROM [DocumentManagement].[dbo].[LesDescription] as d

inner join [DocumentManagement].[dbo].[LesCities] as c

on d.account =...

karan@SqlLearner (9/19/2016)

---

Thank You so much for your reply.

We tried Attunity provider but we were getting some error "TPT Export error encountered during Initiate phase", because we could not fix...