Executing a DTS package via .NET
how can i execute a dts package in sql2000? i tried using the code below with no luck.
the error i get is:
An unhandled exception of type
'System.Data.SqlClient.SqlException' occurred in system.data.dll
Code:
Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection
Me.SqlCommand1 = New System.Data.SqlClient.SqlCommand
'
'SqlConnection1
'
Me.SqlConnection1.ConnectionString = "workstation id=""USER"";packet size=4096;integrated security=SSPI;data source" & _
"=""AUS-REPORTING"";persist security info=False;initial catalog=Log"
Me.SqlCommand1.CommandText = "exec TESTTT"
Me.SqlCommand1.Connection = Me.SqlConnection1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.SqlConnection1.Open()
Me.SqlCommand1.ExecuteNonQuery()
Me.SqlConnection1.Close()
End Sub