Importing excel files having variable headers

by

This has been documented well in MSDN , running through the steps similar to as @houseofsql mentioned

Step1:

Exclude column names in first row in excel connection, use sql command as data access mode
enter image description here

Step2: Alias column names in output column as matching your destination,

Select * from [Sheet1$A2:I] will select from second row

enter image description here

Finally Add destination as OLEDB destination

enter image description here

More Related Contents:

  1. Import Excel spreadsheet columns into SQL Server database
  2. SSIS Excel Import Forcing Incorrect Column Type
  3. How do I pass value to a stored procedure parameter in OLE DB Source component?
  4. Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
  5. SSIS reading LF as terminator when its set as CRLF
  6. Dynamically assign filename to excel connection string
  7. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  8. How to handle this scenario in single SSIS package?
  9. convert Excel Date Serial Number to Regular Date
  10. How can I import an Excel file into SQL Server? [closed]
  11. How to load an XML file into a database using an SSIS package?
  12. Automate Version number Retrieval from .Dtsx files
  13. Query a database based on result of query from another database
  14. Running an SSIS Package using dtexec
  15. SSIS Source Format Implicit Conversion for Datetime
  16. How to Map Input and Output Columns dynamically in SSIS?
  17. Reverse engineering SSIS package using C#
  18. Temporarily disable all foreign key constraints
  19. Convert from DateTime to INT
  20. What are the differences between Merge Join and Lookup transformations in SSIS?
  21. Using SSDT, how do I resolve SQL71561 errors when I have a view that references objects in a different database?
  22. How to execute SSIS package when a file is arrived at folder
  23. How to avoid SSIS FTP task from failing when there are no files to download?
  24. How to create materialized views in SQL Server?
  25. SQL Server Random Sort
  26. SQL Server database backup restore on lower version
  27. Add a new table column to specific ordinal position in Microsoft SQL Server
  28. Merge multiple rows into a single row
  29. Taking the second last row with only one select in SQL Server?
  30. How to Bulk Insert from XLSX file extension?

Leave a Comment