MS online books say the following: Use the schedule
option in the DTS run utility (dtsrunui) if you need to
schedule a package saved as a structured storage file.
Well, I've tried using the dtsrunui but it does not allow
me to "schedule" the package. I can run the package but
not schedule. The "schedule" button is greyed out. Can
anyone tell me why?

Can you tell me which page that is on as I can't find it in the docs I am
reading i.e

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts
sql.chm::/dts_tools_other_8reb.htm

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts
sql.chm::/dts_pkgmng_4hm6.htm

I do not believe you can schedule the package from here rather create the
cmdline that you can then copy and paste into a SQL Server job step.


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Renita" <rsumblin (AT) dropthis (DOT) gannett.com> wrote

In article <uxA6L9ioDHA.3024 (AT) tk2msftngp13 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
In addition...

You can schedule a package, but not a storage file package so docs are
wrong. (BOL feedback time). Guess it is because to scheduled you need to
be connected to a server, and when using storage files you aren't
connected through DTSRunUI.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org