Hi,
Can any body help me out how to execute a single task in
dts package through programetically. I tried with the
method

object.Execute pPackage, pPackageEvents, pPackageLog,
pTaskResult

but iam unable to do it.


Thanks in advance
Sreedhar.

In article <040101c3ad4e$a676e550$a301280a (AT) phx (DOT) gbl>, sree
<aithasri (AT) mailcity (DOT) com> writes
It is useful if you can gives us the details of the error, and perhaps
even a sample of what raised the error. I guess in this case you
parameters are wrong.

Try something like this-

oTask.Execute oPkg, Nothing, Nothing, CLng(0)


I strongly advise against using this method. For a nice long thread on
the subject including an example try-


http://tinyurl.com/vl48

http://tinyurl.com/vl4c

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org