I have created SSIS package and deployed in SQL Server 2008 in a seprate server, and that package is called using ASP.NET which is different web server, in this web server i have already installed Integration Services, but still when i load the package i am getting below error message.
package errMicrosoft.SqlServer.Dts.Runtime.DtsComException: An Integration Services class cannot be found. Make sure that Integration Services is correctly installed on the computer that is running the application. Also, make sure that the 64-bit version of Integration Services is installed if you are running a 64-bit application. ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {BA785E28-3D7B-47AE-A4F9-4784F61B598A} failed due to the
following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
can you please help if am missing any settings or runtime service to be installed in web server.
Below is my code that is used to execute the SSIS Package.
Dim pkg As Package
Dim app As Application
Dim pkgResult As DTSExecResult
app = New Application()
pkg = app.LoadFromSqlServer("\\" & SSISPackageName, DB_ServerAddress, Nothing, Nothing, Nothing)
pkgResult = pkg.Execute()
If (pkgResult = DTSExecResult.Failure) Then
For Each local_DtsError As Microsoft.SqlServer.Dts.Runtime.DtsError In pkg.Errors
Next
End If