asp.net and dts

[rac55]

Hi

Does anyone know how to invoke a dts from asp.net web page? 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

sServer = "Local"
sPackageName = "DTS_ExamResults"
sMessage += theUser
'Load(Package)
oPKG.LoadFromSQLServer(sServer, ,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,
sPackageName)
opkg.Execute
opkg.UnInitialize()

End Sub

Its keeps returning Type 'DTS.Package' is not defined, I have tried importing the dts namespace, but again an error occurs.

Any help would be greatly appreciated

Thanks

 

[pabloj]

Always try Google first ... anyway, a good resource is

http://www.sqldev.net/

where you can also find a "cookbook"

Stick to your guns