Using SSIS 2005 to strip out bad rows in Excel and then insert detailed rows into OLE DB Data Source

• dba321

  Hall of Fame

  Points: 3917

  More actions

  April 6, 2006 at 7:22 am

  #112478

  Environment:

   

  Running this code on my PC via VS 2005

  .Net version 2.0.50727 on the server (shown in IIS)

  Code is in ASP.NET 2.0 and is a VB.NET Console application

  SSIS 2005

   

  Problem & Info:

   

  I am bringing in an Excel file.  I need to first strip out any non-detail rows such as the breaks you see with totals and what not.  I should in the end have only detail rows.  I'm not sure how to first strip this information out in SSIS specfically how down to the right component and how to actually code the component to do this based on my Excel file here: http://www.webfound.net/excelfile.xls

  Then, I assume I just use a Flat File Source coponent or something to actually take the columns in the Excel and split into an OLE DB Datasource to shove each column into a corresponding column in my SQL Server Table.  I have used a Flat File Source in the past to do so with a comma delimited txt file but never tried with an Excel.

   

  Desired Help:

   

  How to perform

   

  1)       stripping out all undesired rows

  2)       importing each column into sql table

• April 10, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  April 11, 2006 at 4:21 am

  #631872

  If I'm not mistaken you posted this on the SSIS forum and I havea  vague recolelction of answering it there.

  If I'm wrong then let me know!

  -Jamie

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson