hi,

i have made a package in SQL SERVER 2000 and then execute it from
vb.net

the source file is .txt file and the destination is sql table.
now the source file's path is to be given at runtime thru vb.net code.

i used the following code:




Dim dtsImport1 As New DTS.Package2

Dim stp1 As DTS.Step

With dtsImport1

.LoadFromSQLServer("servername", "", "",
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrus tedConnection, , , ,
"insert_pkg")

.Connections.Item(1).DataSource = "C:\" +textbox1.text+
"\filename.txt"

.FailOnError = True
.Execute()
End With




but it is giving error that package execution failed.....copy step
failed...



plzzzzzz can any1 tell me wats wrong with this code and how should i
assign filepath at runtime while i have already given a path to
connection1 when making the package..