Hi,

I am struggling with SSIS and will appreciate any help offered.
Can someone please help me?
Thanks

I have an excel document that contains a heading and subheadings with values such as

HEADING LTD.

AC AT ->(SUBHEADINGS)
XX E12
UU GG01

I need to insert the values into a table in sql server. The table contains the columns AC and AT also. No nulls are allowed in the table.
How can I ignore the HEADING LTD. when importing to sql?
Also, if i have 12 rows in my excel the ssis package will try to insert more than 12 rows and i get the error:
[OLE DB Destination [901]] Error: There was an error with input column "A#C" (1161) on input "OLE DB Destination Input" (914). The column status returned was: "The value violated the integrity constraints for the column.".

Don't know if this is going to be of any help,but if you use the import/export wizard in SQL server for that database, from the drop down menu on the first screen for the datasource ,choose Microsoft Excel, choose your excel spreadsheet, there is an tick box which should be checked by default 'First Row has column names'. If ticked then the import wizard will ignore the first row which contains your column headings and not use these as data values but use them as the column headings for your table . If you are importing a CSV file, choose 'Flat File Source' as your datasource and tick the tickbox 'Column names in first data row' and put double quotes in the 'Text qualifier' field. You may have to remove the double double quotes from the file via notepad before importing. e.g. replacing """ with " to signify an empty value in the column or surrounding the data in the field i.e """ <value>""" with "<value>".

Hope this helps

Is the "AC" in your example ALWAYS in the same cell on the spreadsheets?

--Jeff Moden