Friday, April 21, 2017

SSDT Error Message: Unable To Cast COM Object of Type…

Just a short blog post today explaining a problem (and solution) I ran into when working at a client recently. Hopefully it is helpful for anyone out there.

Problem

I recently got this error message at a client when trying to open an SSIS solution in SSDT.

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100'

The reason could be a badly applied Service Pack or CU for example, but I’m not entirely sure about that (source).

Solution

Before starting, make sure you close any open Visual Studio instance.
In a Command Prompt go to the following path (be sure to start the Command Prompt as Administrator):

C:\Program Files\Microsoft SQL Server\120\DTS\Binn\

where 120 is you SQL Server version number.
Reregister the dts.dll by executing the command:

regsvr32 dts.dll

image

If all goes well you should see the following message pop up:

image

I found info here.

Happy coding :)

Tuesday, April 11, 2017

T-SQL Tuesday #89: The Times They Are a-changing

TSQL2sDay150x150

This months T-SQL Tuesday is hosted by Koen Verbeeck (@Ko_Ver) on the topic how the cloud will change and maybe has already changed our jobs as data professionals.
This idea was inspired by Kendra Little’s (@Kendra_Little) blog post Will the Cloud Eat My DBA Job? I listened to the podcast version of her post and here are my 2 cents to the party.

 

Monday, March 20, 2017

Dynamics 365 Tech Conference 2017 Keynote day 1

I finally came around posting the first blog of the D365 Tech Conference. I’ll be posting some more content and an overview of the conference along the next few days.

Points covered

Roadmap AX from 90's to 2017+

Challenges in ERP deployments

  • Change
  • Business process
  • Data quality

clip_image001

Customer showcase: Maersk Container Industries
Implementation in China, Chile and Denmark with 500+ users.

Customer showcase: Peet (Australia).
Financial management with Power BI and MR.

 

D365fO roadmap

Fall 2016 release
Analytics and mobile experience
10 workspaces with PBI dashboards
Mobile expense reports

Spring 2017 release
Common Data Service updates

clip_image002


View into product insights
with Olga Mulvad:
IoT, Social listening, PBI
Product Explorer, impl. with CDS

Deployment options

  • Cloud
  • Cloud + edge (hybrid)
  • Local business data

Demo: Operations take place in Edge, eveything can be viewed and reported in the cloud