error in package execution

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  June 12, 2008 at 8:46 am

  #187873

  Hi,

  I have an SSIS package ..it has 2 sql script tasks and 1 transfer sql server object task....It works fine in BIDS...but when I was trying to execute it by going to its location with .dtsx file...It gives me the following error

  Error: Validation method on the task failed and returned error code 0x80131501(failed to connect to the server ) The validate method must succeed and indicate the result using out parameter.

  Does anyone know how to solve this issue?? any help would be appreciated...

• Jerry Frith

  SSC Rookie

  Points: 26

  More actions

  May 15, 2009 at 4:06 pm

  #995739

  I had the exact same issue. Did you get an answer? Thanx, Carl

• cortier

  SSC Rookie

  Points: 38

  More actions

  May 22, 2009 at 12:05 pm

  #999071

  Check your connection string.:-)