Sql server agent job ssis package execution

• putar

  Grasshopper

  Points: 19

  More actions

  August 16, 2007 at 6:39 pm

  #176281

  i have ssis package that uses couple of excel files. i made a sql server agent job to execute the package as follows:

  exec xp_cmdshell 'dtexec32 /FILE "......"'

  when i start this job manually its runs successfully however it doesn't store imported data into the database tables like it should. another thing is that when i run the same package locally through VS its runs fine and stores the data in tables just fine.

  any ideas what could be the issue?

  any help is greatly appreciated.

• Mohit Nayyar

  Ten Centuries

  Points: 1008

  More actions

  August 16, 2007 at 10:49 pm

  #727538

  http://support.microsoft.com/default.aspx/kb/918760

  I guess this link will be useful for you, I had the same SSIS issue sometime back and that was the easy fix.

   

  Thanks
  Mohit Nayyar
  http://mohitnayyar.blogspot.com/
  "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"