Hi,

I moved one of my DTS package from development to production using
'DTSBackup 2000' successfully and it also executes fine. However, when I
schedule it to run as a scheduled task, it fails with the following error:

Executed as user: TDBFG\SQL-SERVICE. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string:
Error opening datafile: Logon failure: unknown user name or bad password.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider Help file: DTSFFile.hlp Help context: 0 Error
Detail Records: Error: 1326 (52E); Provider Error: 1326 (52E)
Error string: Error opening datafile: Logon failure: unknown user name or
bad password. Error source: Microsoft Data Transformation Services
Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution
complete. Process Exit Code 1. The step failed.

Recently, the TDBFG\SQL-SERVICE password was changed but SQL Server services
were not restarted. Could this be the reason? However, at the same time, I
have another DTS package that is also scheduled to run using
TDBFG\SQL-SERVICE to execute the package, and it runs successfully. So, I'm
confused what could be causing this error.

Any help will be highly appreciated. Thanks in advance.

Note: both servers are SQL Server 2000 SP4.

Hi Rob,

I have a very similar problem. I can quite happily execute my package from
the designer but as soon as I try to schedule it fall over with the same
error message. Very perplexing......



"Rob" wrote:

Hi,
I had same problem, this article was very helpful:
http://support.microsoft.com/kb/269074/EN-US/

Basicall, make sure that owner of the scheduled job is a member of SQL
server SystemAdministrators group. Also make sure that NT account used to
start SQL Server service and SQL Server agent, has permissions to your source
and destination files (shares).

Zoran

"Rob" wrote: