Job failed due to Warning in Source select statement

• ravoof99

  SSC Journeyman

  Points: 75

  More actions

  July 12, 2010 at 11:53 pm

  #139782

  Hi,

  I have SSIS job fetching datda from SQL source.I am getting some warning message when running the query.and job is failing in prod.But the job is successfulin acceptance with the same source(even though warning is coming).Please help

• gayathridevi.msit

  Ten Centuries

  Points: 1294

  More actions

  July 13, 2010 at 12:04 am

  #1191796

  Hi,

  Provide the warning message.. so that ll try to help u

  Regards,
  Gayathri 🙂

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  July 13, 2010 at 5:08 am

  #1191913

  Are you sure it is not a permission issue?

  Also, in production. is there only a warning or also an error? How does it fail?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  July 13, 2010 at 5:25 am

  #1191917

  if the package is passing QA and failing in Production it has to be an issue with permission

  Raunak J