Issue deploying SSIS Package in production web server
-
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 DTSExecResultapp = 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 '' Logging Errors Next End If
Shuaib