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


Reply With Quote