Need help understanding error

Question

Need help understanding error

Peter Newman-311337

Old Hand

Points: 394
More actions
September 5, 2007 at 6:19 am

#176379

I have created a simple project to execute a DTSX on our SQL Server.
The application was built on my Workstation ( Windows XP Pro SP2, Visual Studio 2005, SQL Server 2005)
The application returns the dtsx executed sucessfully.
Project comprises of a form and a button
Code:
Imports System
Imports System.IO
Imports Microsoft
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim pkgLocation As String = ""
Dim App As New Application
Dim pkg As New Package
Dim ExecEvent As IDTSEvents90
Dim result As DTSExecResult
pkgLocation = "\\Sql1\2007_DTS\FTPSLAVE.dtsx"
Try
pkg = App.LoadPackage(pkgLocation, False, ExecEvent)
result = pkg.Execute
MsgBox("DTS Executed - result - " & result.ToString)
Catch ex As Exception
MsgBox(" Execution error " & ex.Message)
End Try
End Sub
End Class
however when publishing this application to the targer server ( Windows 2003 server ) and running the application i get the following error
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error. 80040154
i have seen this error posted before in other threads but have not been able to understand why im getting it and how to resolve it. Any help would be most appriciated
Thanks in advance

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

Does the machine running the package have the DTS runtime components installed? Are you creating an install package (which would have the extra pieces like the DTS runtime DLL in it?)

In 2K - you could simply run the install for the workstation components and it would install the components with it. Haven't had the pleasure to test that out on 2K5.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Peter Newman-311337 Old Hand Points: 394 More actions · Answer 2

The destination machine is windows 2003 server with SQL Native Client Installed, so im guessing theres some bits n peices im missing from there. As for the Application, im just using the publish function from visual studios 2005 and then running the install on the destination machine .

Not sure where i need to look or what i need to install

********* Update *******

I have now installed Intergration services on the destination server and its all working

Thanks for the pointer