Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
 Posted - 2010-03-14 : 04:49:26
|
| I want to run job that execute DTS I use Operating system command to execute "C:\PROGRAM FILES\MICROSOFT SQL SERVER\80\TOOLS\BINN\Dtsrun.exe" /S "ssss" /U "sa" /p "sss" /N "dsdsds" /W "0" /E /A Conn:8="provider=SQLOLEDB.1; data Source= sdsds initial catalog= xx; User ID= sa; pwd=ttt " /A Path:8="\\dfdsfds\fffff\" it always give me the following error :Executed as user: FNS\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun: Package execution complete. Process Exit Code 1. The step failed.I don't know why give access denied, while when running it manualy use enterprise manager work very well, and I am admin on the server I need urgent help please |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-14 : 17:29:15
|
| Since it is running from a job, the SQL Server service will need to have access to everything that the DTS package needs. When you run it manually from Enterprise Manager, it uses your credentials. However, through a SQL Agent job, it uses the SQL Server service credentials.Is your SQL Server service using the Local System account? If it is, does your DTS package need access to remote resources such as a remote path/share? If it does, then you'll need to change the SQL Server service to a domain account and provide that user the permissions the DTS package needs on the remote resource. I always use a domain account that has local admin privileges on the database server since it makes my life easier.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
Posted - 2010-03-15 : 08:23:52
|
quote:
Originally posted by tkizer
Since it is running from a job, the SQL Server service will need to have access to everything that the DTS package needs. When you run it manually from Enterprise Manager, it uses your credentials. However, through a SQL Agent job, it uses the SQL Server service credentials.Is your SQL Server service using the Local System account? If it is, does your DTS package need access to remote resources such as a remote path/share? If it does, then you'll need to change the SQL Server service to a domain account and provide that user the permissions the DTS package needs on the remote resource. I always use a domain account that has local admin privileges on the database server since it makes my life easier.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
the file at the same server and I can access it, and user sa can import data from it |
|
|
|
|
|
|
|
|
DTS problem