Personally I prefer to call a package through the cmdline and DTSRUN or
through a programming language like C#.
Have a look here as to possibilities.
Execution
(http://www.sqldts.com/default.aspx?104)
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"J-T" <JT (AT) nospam (DOT) com> wrote
Quote:
Is is possible to catch up with the status of steps when you execute a
package using stored procedures? What 's the best way of executing DTS
packages in your application?
Thanks |