Hi

Does anyone know the namespace for dts...I have tried Import Namespace="Microsoft.SQLServer.DTSPkg80" etc but it returns dts.package not defined. My code is;

Sub BtnUpload_click(Sender As Object, E As EventArgs)

Dim opkg As New DTS.Package
Dim sServer As String
Dim sPackageName As String, sMessage As String
Dim sUser As String
Dim lErr As Long, sSource As String, sDesc As String
' Set Parameter Values
sServer = "Local"
sPackageName = "DTS_ExamResults"
sMessage += theUser
'Load(Package)
oPKG.LoadFromSQLServer(sServer, ,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedC onnection, , , ,
sPackageName)
opkg.Execute
opkg.UnInitialize()

End Sub

All I am trying to do is run an existing dts package. Any help would really be appreciated.

Thanks