I have a DTS package that I can execute successfully
through enterprise manager... however, if I sechedule it
or run it through the command prompt... it fails with a
weird error: -2147221499: Need to run the object to
perform this operation.

I have found that if I remove some fields from the
transform data task... the package will run through the
scheduler.

I am totally stumped and need this to work. Does anyone
have any suggestions?

Thanks

In message <0dbd01c3f643$a5e11820$3a01280a (AT) phx (DOT) gbl>, Frank
<anonymous (AT) discussions (DOT) microsoft.com> writes
Not familiar with the error, but scheduled packages often cause problems
since they normally involve a change in execution location and security
context when compared to packages being developed on a local machine.
Plenty of posts about that on this group, but nothing concrete about the
error.

I would log onto the server itself, under the same account as used by
the SQL Server agent service and manually run the package and see if you
get any more error info from the execution dialog. Also turn on the
package log file and data pump log fle, and also the log to SQL server
option.

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

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

What fields are you removing?

--

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


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

Interestingly enough...

When I log on the actual server and run the DTS Package
locally on through Enterprise Manager. Enterprise manager
crashes. So I don't even need to schedule it to make it
fail.

However, I go back to my pc and run the same package
through Enterprise manager... the package runs fine.

So you are on to something here... exactly what I am not
certain.

I do have a different version of enterprise manager
installed on my PC versers what is on the server.

Frank

In message <831d01c3f64f$36e56b40$7d02280a (AT) phx (DOT) gbl>,
anonymous (AT) discussions (DOT) microsoft.com writes

Frank,

What are the different versions?

I recommend you get the same version of EM on all machines, or if you
are running different major versions, then at least get the latest SP
for each on the appropriate machines.

There is however a bug with SQL 2000 SP3 that can cause EM to crash,
although I don't think this is your problem since you get issues when
scheduled too. To fix this particular bug, apply the SP 3 security
updates as well, which of course you'll already be doing,


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

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