I have set up some DTS packages to import data from an outside ODBC source.
I have scheduled these packages to run automatically by scheduling jobs for
these packages. My question is; when I schedule the package as a job the
command that is generated is some kind of long code like this DTSrun
'Z0xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'

What is this code, some kind of SSID? Why does it use this code rather than
just the package name?

Can I subsitute the package name for this code instead??

Any help appreciated.

Dennis

This section in BOL will explain it all

http://msdn.microsoft.com/library/de...tsrun_95kp.asp

also look at

Getting Syntax Help for DTSRun
(http://www.sqldts.com/Default.aspx?301)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Den" <nomail (AT) nowhere (DOT) com> wrote

Thanks, that helped.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote