Re: Scheduled DTS package fails

#1

Maybe you are seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--
--

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

"Chris" <cfarino (AT) sph (DOT) emory.edu> wrote

Quote:

I scheduled a DTS package to run daily, but it fails saying it can't find
the file specified. There is no file associated with the package. The

package simply copies data from one database to another database. Both
databases are on the same server. The package will run manually from EM and
if I change the agent to run transact SQL commands it will run successfully.
The account the agent runs under is different from the account that created
the package.

#2

select @@version in query analyzer says the server is running SP4. The management console on my machine is on SP1. I don't see any update for MC on the site. We're running SQL Server 2000

#3

In message <19D7A7A2-70E7-4085-B6B2-A44FBA119038 (AT) microsoft (DOT) com>, chris
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

select @@version in query analyzer says the server is running SP4. The
management console on my machine is on SP1. I don't see any update for
MC on the site. We're running SQL Server 2000

There is no separate SP for tools as opposed to the server. Grab any
copy of SP4 and apply to you machine.

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

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

#4

Found a fix. Needed to add: "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe" to the command line in the agent.

#5

Then you are seeing this problem

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

--
--

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

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

Quote:

Found a fix. Needed to add: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\DTSRun.exe" to the command line in the agent.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Scheduled DTS package fails

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Scheduled DTS package fails - 05-12-2004 , 10:36 AM

Re: Scheduled DTS package fails - 05-12-2004 , 12:26 PM

Re: Scheduled DTS package fails - 05-12-2004 , 12:58 PM

RE: Scheduled DTS package fails - 05-12-2004 , 03:31 PM

Re: Scheduled DTS package fails - 05-12-2004 , 03:41 PM