473,405 Members | 2,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Could not execute a package by a scheduled job

I try to set a job to run a DTS package, failed.

My environment is SQL Server 2000 sp4 on windows Server 2003.

There is a local window group called Dev_accnt including member SQLTesting
who is a global account of domain Jackson. local group Dev_accnt assigned in
SQL Server with Login name: LocalMachine\Dev_accnt, type: windows group.
There is no individual Login name assigned to SQLTesting in SQL server.

I used a global account Jackson\SQL_Oper for SQL Server Agent startup
account once, then I change it to global account Jackson\SQLAgentStart and
give SQLAgentStart account with fixed servre role sysadmin, withdraw
sysadmin from Jackson\SQL_Oper. Here Jackson\SQL_Oper or
Jackson\SQLAgentStart joined in different local window group SQLOperation
with no sysadmin rol or SQLAdministrator with sysadmin role separately and
no individual Login IDs in SQL Server, but when use Jackson\SQL_Oper or
Jackson\SQLAgentStart for SQL Server Agent startup account they will be
created a individual Login IDs in SQL Server but under "Server Access"
display "via group memeber". I did not remove these 2 individual IDs from
SQL Server.

Then I use account SQLTesting log in and create package copying a table from
one database to another and create a schedule job for it.

I directly run package work fine, but I run package from its schedule job,
the job failed, no matter it is run by manual or by SQL Agent. The error as
following:

"Executed as user: Jackson\SQL_Oper. ... OnStart:
DTSStep_DTSCreateProcessTask_1 DTSRun OnError:
DTSStep_DTSCreateProcessTask_1, Error = -2147024891 (80070005) Error
string: Access is denied. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 1100 Error Detail Records: Error: -2147024891
(80070005); Provider Error: 0 (0) Error string: Access is denied.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 1100
Error: -2147024891 (80070005); Provider Error: 0 (0) Error
string: Access is denied. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 4900 DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun: ... Process Exit Code 1. The step
failed."

Then I remove Jackson\SQL_Oper from SQL Server and from local windows group
of window server 2003 which SQL Server installed. I run job again get error
message as following:

Executed as user: Jackson\SQL_Oper. DTSRun: Loading...
Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Error
string: Login failed for user 'Jackson\SQL_Oper'. Error source:
Microsoft OLE DB Provider for SQL Server Help file: Help
context: 0. Process Exit Code 1. The step failed.

Some one has some idea about this problem?
Jul 8 '08 #1
0 2529

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: ano1optimist | last post by:
I've tried several different possibilities but don't have enough basic understanding of the ownerships and permissions that are involved so I'm looking for someone to explain what is required: I...
2
by: Ciar?n | last post by:
I want to create a DTS package that will. Cleardown all rows in a table called stock Then populate stock with all data from another table called stock1. I also want to schedule it to run...
2
by: Rich Tasker | last post by:
My goal is to execute a DTS package that calls multiple child DTS packages from a C# (2003) app and display the progress of the entire process to the user. I have followed the model defined in...
3
by: Grant Ord | last post by:
I've never found a simple answer to this yet it must be an issue for a lot of web applications. Basically I want to execute code in a web application at a specific time and/or intervals (like...
1
by: Dean R. Henderson | last post by:
I have a Windows library that I bind into a Windows Form application and into an ASP.NET Web Application. I have a procedure in the library that executes a DTS Package. I have also used...
1
by: KR | last post by:
The DTS package runs fine through Enterprise manager successfully. However, when scheduled through a job that runs the dts through the following code: DECLARE @findfile int Exec @findfile =...
0
by: grizzcol | last post by:
hi, I have a scheduled job that runs a DTS package. However the package is not referenced by name but by something like the following: DTSRun /~S 0x8BB73D744E60A78F935E38CCED793ADE /~N...
0
by: rmsterling | last post by:
DSN ODBC pwd not saved when SSIS package imported SQL Server 2005 SP2 (Windows 32bit version) Implemented and FULLY tested a SSIS package with BIDs. This package uses a Data Reader object...
0
by: Anuradha Thangaraj | last post by:
Hi Friends, I am trying to execute the Scheduled Task from the Server with all the client machine thru VB.Net code. I need to know how to Access the Scheduled Task of Client machines from the...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.