Package Validation failing - Connection problem

• patrick h

  SSC-Addicted

  Points: 425

  More actions

  February 8, 2008 at 5:22 am

  #120573

  Hi,

  I recently received a new laptop at work with windows vista on it. Having BIDS 2005 installed I wanted to modify an existing package (stored on our network) that I developed months ago. But I can't execute this package on that machine as I get this error:

  [Connection manager "MyConnectionManager"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  [Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyConnectionManager" failed with error code 0xC0202009.

  I really don't understand this because the connection manager works ok. Plus I use package configurations with settings stored on a SQL Server 2005.

  Also, the same package works fine on the older machine.

  Any ideas ?

  Thanks in advance

  Pat

• Frank Bazan

  SSCertifiable

  Points: 5378

  More actions

  February 8, 2008 at 6:38 am

  #776376

  Reboot!!! It usually works for me!

  Kindest Regards,

  Frank Bazan

• patrick h

  SSC-Addicted

  Points: 425

  More actions

  February 8, 2008 at 7:03 am

  #776398

  Thanks, but i've found the solution : actually my firewall settings prevented any actual connection to a remote database.

  I changed them and now it's ok.