Hi ,

Where can I get the DTS package ID and what is the commad to run that
package using that Package ID in the SQL Scheduler ?

--

You can look in msdb.dbo.sysdtspackages.

Why do you want the ID? does the name not do it for you?

Look up DTSRUN in BOL for the list

/G is the package ID switch

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


[quoted text, click to view]