I want to know if there is any other way to run a dts, like using a query, if
yes plese let me know the query or where can the information

There are lots of ways to run DTS packages without requiring Enterprise
Manager. DTSRun and DTSRunUI work from the command line. they can also be
programmatically executed via application code. Check out Darren and
Allan's site, http://www.sqldts.com, for some great coding examples
including one for launching a package using TSQL.

--
--Brian
(Please reply to the newsgroups only.)


"Gottu" <Gottu (AT) discussions (DOT) microsoft.com> wrote