Hello

I am trying to execute a dts package from a scheduled job,
when i schedule the job from the package it appears in the
jobs list but fails. I have tried quite a few commands
like dtsrun and execute in the job step but don't have
enough knowledge in this area...

also, I previously asked about how to overwrite a table in
Access when using a package to dump data into Access but
neglected to say that it was via a schedule hence I need
to set it automatically but i can't find anywhere to say
overwrite rather than append in my dts package...

any help is greatly appreciated
thanks
Alison

Without any errors to go on it is difficult for anybody to troubleshoot the
errors you are getting. I suspect though you are seeing this

http://support.microsoft.com/?kbid=269074

As for overwriting you can issue a DELETE statement on the Access connection
prior to pumping the new rows

--
--

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


"Alison Towerton" <anonymous (AT) discussions (DOT) microsoft.com> wrote