sql server dts: Hello and Merry Christmas to all,

I would like to execute a DTS from my ASP.NET web page written VB.NET. How
can I do this?

I have the following:

Imports DTS.PackageClass

Dim oDTS As New DTS.Package

Try

oDTS.LoadFromSQLServer(m_ServerName, m_UserName, m_Password ,
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , "StopFile", 0)

oDTS.Execute()

Catch ex As Exception

If oDTS.FailOnError Then

Trace.Write(ex.Message + ", Failure")

Else

Trace.Write(ex.Message)

End If

Finally

oDTS.UnInitialize()

End Try

The following has great examples on using .NET to work with DTS:

http://www.sqldev.net/dts/DotNETCookBook.htm

Hope this helps,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.