Calling SSIS from SQL Server Agent Doesn't Run No Error Given

• Margaret Norkett

  SSC Veteran

  Points: 203

  More actions

  January 29, 2009 at 9:32 am

  #128279

  I call an SSIS package with a SQL Server Agent Job.

  The first "step" in the SSIS package is to move files from one folder to another. This step never executes. The next tasks are to generate a new file and ftp that file to a location. This part seems to work.

  Why isn't the first task executed from the SQL Agent job?

  This job never reports an error.:w00t:

  ---

  Thanks and have a NICE day!,

  Margaret
  

• mariekaldjob

  Valued Member

  Points: 51

  More actions

  September 29, 2011 at 8:28 am

  #1388398

  Hi,

  I call an SSIS package from Job SQL.

  The job is 'success' but, data are not populated in my tables;

  I use the SQL Agent for running the Package.

  Can someone helps me about that?

• Naeblis

  SSC Enthusiast

  Points: 132

  More actions

  February 1, 2012 at 8:45 pm

  #1441523

  SSIS jobs must use a proxy

  create a proxy.

  map the proxy to credentials

  select proxy in drop down in agent job

  profit

  Naeblis