IS it possible to run a DTS command through query analyzer so that data
is picked up from mysql on Linux platform and transferred to MS SQL
enterprise edition on win 2000 server platform.

If there are alternate means suggest. I do not have admin rights on the
linux platform and can retrieve data from DTS and view data also, but
cannot make modifications on the linux platform.

The requirement is to generate reports dynamically for which data needs
to be mirrored on the MS SQL platform every hour.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can certainly fire a package through TSQL yes

Have a look here

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.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Preet Kanwaljit Singh Shergill" <preetsinghasr (AT) hotmail (DOT) com> wrote in
message news:%23PC0npoNEHA.2976 (AT) TK2MSFTNGP10 (DOT) phx.gbl...