Error when extracting data from Excel

• ioani

  Ten Centuries

  Points: 1295

  More actions

  January 8, 2010 at 1:31 am

  #386062

  Hi,

  I created a package that extract data from an Excel file into table in a database with BIDS 2008. When I am trying to preview the the data from Excel Source in Data Flow Task, I get the following error:

  ===================================

  There was an error displaying the preview. (Microsoft Visual Studio)

  ===================================

  Index and length must refer to a location within the string.

  Parameter name: length (mscorlib)

  When I am trying to to run the package, I get the following error:

  ===================================

  Package Validation Error (Package Validation Error)

  ===================================

  Error at ImportDataFromExcel: The connection "{489FCFF6-4602-4BFC-B923-2B1E8D0A7313}" is not found. This error is thrown by Connections collection when the specific connection element is not found.

  Error at Import PEP [SSIS.Pipeline]: Cannot find the connection manager with ID "{489FCFF6-4602-4BFC-B923-2B1E8D0A7313}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "runtime connection "IDbConnection" (3335)" in the connection manager collection of "component "ADO NET Destination" (3333)". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.

  Error at Import PEP [SSIS.Pipeline]: component "ADO NET Destination" (3333) failed validation and returned error code 0xC004800B.

  Error at Import PEP [SSIS.Pipeline]: One or more component failed validation.

  Error at Import PEP: There were errors during task validation.

  (Microsoft.DataTransformationServices.VsIntegration)

  Thanks,

  ioani