Unable to cast COM object of type ApplicationClass to interface type IDTSApplication160
Action:
After installing Visual Studio, SSIS and CozyRoc SSIS+ I am not able to create or open SSIS my SSIS projects. When I uninstall CozyRoc SSIS+, then Visual Studio and SSIS appear to be working as expected (minus the CozyRoc connectors and tasks).
Error Message:
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSApplication160'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{037FE238-12C5-4313-AE13-9E116E90ACEA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.SqlServer.ManagedDTS)
Solutions:
Microsoft implemented some sort of breaking change. As a result, COZYROC implemented a fix for this error message in version 2.0.100.1903.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error message: Creating an instance of the COM component with CLSID {..} from the IClass Factory failed due to the following error: 80040111
Action: I get the following error when I attempt to update the COZYROC SSIS+ license. I am using the Windows Server 2019 Core and am selecting the corresponding License.dat file for the specific SQL version I'm using by clicking on the folder button. ...OpenAir Destination: How to modify the OpenAir Destination type dynamically at runtime
The destination type is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination type. Right-click on the data flow canvas and select ...Error Message: unable to allocate memory
Action: While using the Oracle Destination, the following error message was returned. Error Message: 'Oracle.DataAccess.Client.OracleException (0x80004005): Impossible d'allouer de la m魯ire (unable to allocate memory in french) at ...What connection type and port should I use with the FTPS connection?
The most commonly used connection type is ExplicitTLS and the most common port for this is 21. If these don't work, talk to the administrator of the SFTP server you want to connect to to find out which protocol and port to use.Variables may not change type during execution. Variable types are strict, except for variables of type Object.
If you want to get a list of files from a folder on the remote host using the File Transfer Task, use the 'Get remove files list' Action and set up a variable of type 'Object' to receive the list.