We have created a DTS package and moved it to another server as a structured storage file.
When running it all the steps worked fine, but when schedules we noticed we had data missing from one table.

After some time trying to track down the problem it turned out that one of the workflows was incomplete compared to the original server. It seems that it may not have saved correctly. So our problem is solved but we wondered has anyone else seen a similar problem?

Thanks

Never seen this problem before and technically it should not happen. If you
can execute it manually correctly but it is incomplete when scheduled then
could it be realted to permissions i.e.

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

There should not be things missing physically from the package when executed
manually v Scheduled though.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"Andrew Mogford" <anonymous (AT) discussions (DOT) microsoft.com> wrote

it may not have saved correctly. So our problem is solved but we wondered
has anyone else seen a similar problem?