473,221 Members | 1,712 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,221 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 2518

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...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.