job fails on cluster server

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  October 24, 2007 at 9:44 am

  #376520

  Hi all,

  I have cluster environment for SQL 2005... I have SSIS package running. I am running package in bat files. i have same directory created on clustered server alike on the main production server!! but when the SQL fails over to culster from A to B. jobs fails...

  why? and what shouldi do now!!

  Thanks

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  October 24, 2007 at 12:20 pm

  #745071

  Although MS doesn't recommend clustering SSIS, you can avoid these types of issues by doing so. I've personally never experienced a problem with it.

  http://msdn2.microsoft.com/en-us/library/223c3a59-84c3-4f60-be98-a8daf69e9473.aspx

  Tommy

  Follow @sqlscribe

• Dhananjay-440114

  Ten Centuries

  Points: 1365

  More actions

  October 25, 2007 at 1:20 am

  #745249

  Are u using same directory structure on server A as well as server B ? If not pls. use.

  Regards

• Nebojsa Ilic

  SSCommitted

  Points: 1735

  More actions

  October 25, 2007 at 1:26 am

  #745251

  Check if SQL can access this directory from both nodes.

• VaiydeyanathanVS

  Hall of Fame

  Points: 3053

  More actions

  October 25, 2007 at 1:35 am

  #745253

  please configure your jobs again and try to adopt the steps given overhere..

  http://www.domaingurus.com/server-cluster/server-clusters-definitions.html