Excel Data Schema Mismatch With Destination Table In SSIS

hello,

i have folder csv files , excel files(excel files multiple sheets). say, every file's schema of format empid,empname,salary.

i have destination table in sql server same schema empid,empname,salary.

i comfortable in loading these files. problem may files different schema structure empname,departmentname. in case have identify files doesn't have same schema destination table , move these files folder called "schema mismatch files" , create table these dynamically , load these files.

thank in advance.

---

regards, sunil a.

step 1 : retrieve excel schema (see linke how do http://www.mssqltips.com/sqlservertip/1674/retrieve-excel-schema-using-sql-integration-services-ssis/)

step 2.1 condition: if excel in correct schema

2. 1.1 load in static table with same schema empid,empname,salary.

step 2.2: if excel not in desired schema

2.2.1 create new table (execute sql task) 

2.2.2 load data in newly created table

and done.

---

thanks , regards, prajesh please use marked answer if post solved problem , use vote helpful if post useful.

SQL Server  >  SQL Server Integration Services