I have two DBs and I have created a DTS package to import data from one to
another DB and I have saved it in SQL (Data
Transformation Services --> Local Packages).

Is there any way to execute it from Query Analyzer?

Thanks
Dimitris

The most obvious way is to use
exec master.dbo.xp_cmdshell 'DTSRUN ..........' with all the parameters.

Use the package DTSRUNUI.exe to easily find the dos command string you need.

Alternatively schedule the package (right click on it and schedule). Go to
the Job and copy and paste the DTSRUN statement to the XP_CMDSHELL above.
(Only it will give you the encrypted version - works OK - you just cannot
read it.)

--
Brian Reincke
Parity Training
Lonbdon


"Dimitris Nikolakakis" <dn (AT) hol (DOT) gr> wrote