Running DTS's from Access

#1

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.

#2

In article <048801c3be9d$e6b8cec0$a301280a (AT) phx (DOT) gbl>, chalaka
<anonymous (AT) discussions (DOT) microsoft.com> writes

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.

I believe you should be able to adapt VB samples to work in Access VBA,
in which case this should help-

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208)

Does it?

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Running DTS's from Access

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Running DTS's from Access - 12-09-2003 , 03:46 PM

Re: Running DTS's from Access - 12-09-2003 , 04:19 PM