There is no property in Access but you can check the outcome of the package
and steps within.
Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208,1)
--
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
"chalaka" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
I just learnt how to run SQL DTS from Access. I now need
to check programatically, if the DTS runn with out an
error. Is there are a property in access to do this? If so
let me know how.
thank you |