March 13, 2006 at 11:39 pm
I have created .DtsX File and Schedule on SQL 2005 Jobs,
When i tryed to run mannaully its working fine but when i created job in SQL 2005. Its giving an error "Executed as user: LocalServerName\SYSTEM. The package execution failed. The step failed.".
SQL Agent Service runs on "LocalSystem" Accouny
March 15, 2006 at 2:18 am
Its probably a security issue. You'll quite often find that packages that execute OK in BIDS don't execute under Agent. The package will execute under the security context of the user that executes it so check that the localsystem account has access to all the external data sources that are using Windows Authentication.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
March 17, 2006 at 10:30 am
desde el command prompt teclear :
DTExec /f "c:\folderDTS\sample.dtsx"
con esto estariamos corriendo el DTS desde command prompt despues hay que usar el "Shedule Task" de Windows y correr esta instruccion con esto estariamos dandole la vuelta al problema de que no podemos correr un DTS desde el JOB
Saludos y espero les sirva mis comentarios
Atte. Rae Limon Mtz
Mty., N.L. Mex.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply