DTS will not run using SQL ADMIN

[klewis10367]

I have a dts package that when run manually it works using my windows nt account...but when the dts is saved and run through a job it uses the sql admin account (which is the account that starts the sql server agent) and it will not run. Any ideas?

 

[mrdenny]

Odds are the SQL Account doesn't doesn't have rights to what ever folder / file, etc the dts package is using.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[klewis10367]

Rights are not a problem. Full permissions on the executables folder...the executable is running but the parameter associated with it will not run when using the sql admin account.