The index is not valid

• Dinu E Anastasiu

  Ten Centuries

  Points: 1177

  More actions

  February 27, 2006 at 10:53 am

  #167219

  An Excel Source Data Flow object (which used to work fine) sudenly started display the following error box:

  TITLE: Microsoft Visual Studio

  ------------------------------

  Error at Create BusStop Table [DTS.Pipeline]: The index is not valid.

  ADDITIONAL INFORMATION:Exception from HRESULT: 0xC0048004 (Microsoft.SqlServer.DTSPipelineWrap)

  What could be the cause?

  What is the meaning of: HRESULT: 0xC0048004 ? How could this info be used?

  Thanks and best regards,

  Dinu

   

   

• david russell-253790

  SSCarpal Tunnel

  Points: 4042

  More actions

  February 27, 2006 at 1:28 pm

  #623539

  The SSIS error messages are here:

  http://msdn2.microsoft.com/en-us/library/ms345164.aspx

  unfortunately it doesn't tell you much more than you already know:

  0xC0048004

  DTS_E_INVALIDINDEX

  The index is not valid.

  Maybe someone from MS will see this and respond?

  ---

  Cheers,

  david russell
  

• steve ranker

  Valued Member

  Points: 70

  More actions

  September 12, 2006 at 7:43 pm

  #659999

  I got this same message.

  Here was my work around.

  I went into the Excel file, copied the entire range, paste special - > Values to a new sheet.

  Fixed the problem.

  I have no idea what caused it.