Assalam-o-Alaikum
i am working on the project with sqlserver2000 as database tool and
vb.net as frontend tool we have to import the data from text file in
the sqlserver ,for which we have created and save a DTS pakage in sql
and execute it from vb.net, it works properly but as the data size is
too large the execution of DTS package takes a lot of time during which
the fontend screen becomes idle, we are trying to show at that instant
the progress bar which monitors the execution of package but we are
unable to findout pakage execution time,we r bothering in for how long
we have to run progress bar so that it run in similar pace with the
package execution, could we import the sql dts progress bar enviroment
that runs when we execute it on sql serverl, something like,this in
vb.net

here is the coding to run sql package in vb.net

With dtsImport
'.LoadFromSQLServer("computer44", "", "",
"DTSSQLStgFlag_UseTrustedConnection", , , , "insert_pkg")
.LoadFromSQLServer("computer44", "", "",
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,
"insert_pkg")

'.GlobalVariables.AddGlobalVariable("PROMPTEDVALUE",
DTSParameter)

.FailOnError = True
.Execute()
End With

any other idea or suggestion is highly appreciated

thanx
regards