SSIS Problem : [Execute SQL Task] Error: Failed to acquire connection "MANIFEST.ManifestMDB". Connection may not be configured correctly or you may not have the right permissions on this connection.

• conningtower

  Say Hey Kid

  Points: 675

  More actions

  July 22, 2010 at 11:07 am

  #144198

  When i run the individual task it works and executes correctly but when i run the package as a whole it doesnt work.

  I even tried it with Windows Authentication and it still doesnt work.

  Please help

  G

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 23, 2010 at 5:55 am

  #1197442

  Check if this helps

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga