I have SQL 2K and I have created a local package to import data from Access
mdb and I have saved it in Data Transformation Services --> Local Packages


I would like to know if this can be executed from SQL query analyzer.

Thanks
Dimitris

One option is to use xp_cmdshell and execute dtsrun. Along
the lines of:
use master
go
exec xp_cmdshell 'dtsrun /SYourServer /NYourPackage /E'

You can find more information about dtsrun in SQL Server
books online.

-Sue

On Tue, 16 May 2006 13:19:35 +0300, "Dimitris Nikolakakis"
<dn (AT) hol (DOT) gr> wrote: