Unable to cast COM object of type 'System.__ComObject' to interface

-
TITLE: Microsoft Visual Studio
------------------------------
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{203E24BD-5203-4C76-AFC7-7C8545EBA1A0}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).
------------------------------
BUTTONS:
OK
------------------------------

Solution:

1. Before starting, make sure you close any open Visual Studio instance.
2. Open command prompt and run as a administrator.
3. Navigate to bellow path
       C:\Program Files\Microsoft SQL Server\120\DTS\Binn\
where 120 is you SQL Server version number.
 

4. Reregister the dts.dll by executing the command: 
regsvr32 dts.dll
  

Comments

Post a Comment

Popular posts from this blog

Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings

-
Image
We’re excited to announce that you can now embed entire Power BI organizational apps in Microsoft Teams tabs. Until now, this has been one of the top feature requests for Power BI integration with Microsoft Teams. It helps teams and organization put the full Power BI org app experiences directly where people work every day. By adding Org apps in channels and meetings, you enable everyone to access the data they need. We’ve started to roll out the experience to commercial cloud customers and expect it to be available for everyone in the next week or two. Let’s look at the new experience and its benefits. Picking an entire Power BI organizational app to embed in Microsoft Teams To embed a Power BI organizational app, add a Power BI tab to a channel or meeting. Go to the Apps pivot in the selection you and notice the  new checkbox next to the app name . When you check the box, you’re choosing to embed the entire organizational app in the Power BI tab.  If you don’t see an app in ...
Read more

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Dataset refresh cancellation is now available in Power BI Premium

-
Image
We are excited to share that cancelling an in-progress dataset refresh in Power BI Premium, Power BI Premium Per User, and Power BI Embedded just got significantly easier. A top-20 idea on Power BI Ideas (we do listen and appreciate your feedback), we acknowledge that this capability couldn’t have come soon enough for our customers. In the past, cancelling an ongoing refresh was an unreliable process that required external tools. Earlier this year, we released the Enhanced refresh with Power BI REST API, that – in addition to XMLA based refreshes – allows refresh cancellation. However, it requires the refresh operation to be triggered by the API. Today, users can cancel an ongoing scheduled or on-demand refresh using a contextual button in the Power BI service. Earlier limitations that constrained cancellation no longer apply. To begin using this feature in your Premium workspace, no actions are required. Please note that for datasets created as part of Datamart...
Read more