Hi,
I have a simple dts job on sql2000.
I can execute the dts job through asp.net fine using the
following.
Dim newpackage As dts.Package
newpackage = New dts.Package()
newpackage.LoadFromSQLServer("ELTHNTW04\EMS", , ,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedC onnectio
n, , , , "dtsexport")
newpackage.Execute()
newpackage.UnInitialize()
newpackage = Nothing


what I am trying to use is the rowscomplete property of
the datapumptask2 object.
How do I use this in conjunction with the dts package.
I'm looking for a simple example if anyone can help.
Kind regards,

Constantinos

The quickest example I have to hand is from VBScript within a package
Note the package reference is the set PKG statement. I assign the values of
the RowsComplete etc to GVs

Function Main()

dim PKG
dim pmp


set PKG = DTSGlobalVariables.Parent

set tsk = PKG.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask

DTSGlobalVariables("RowsGood").Value = tsk.RowsComplete
DTSGlobalVariables("RowsBad").Value = tsk.RowsInError


Main = DTSTaskExecResult_Success
End Function

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Constantinos" <cflorides (AT) elthion (DOT) com> wrote