Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Issue deploying SSIS Package in production web server

Issue deploying SSIS Package in production web server

Scheduled Pinned Locked Moved Database
helpdatabasesql-servercsharpasp-net
1 Posts 1 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Shuaib Kaniyar
    wrote on last edited by
    #1

    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
                '' Logging Errors
            Next
        End If
    

    Shuaib

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Don't have an account? Register

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups