ssis importing two excel files with different numb

2019-09-01 06:53发布

I want to build a ssis package that imports a flat file with variable number of columns and stores it in a database table. further i will be using that table to left join with few other tables to find if a particular column value matches with the ones i already have in the database. Then i want to give all non matching rows as output in another folder as a csv file.

So how to write a for each loop to import variable column number flat file and store it in a table. Can we write a package to create a table after it imports a file or can we store the imported file in a temp table created dynamically, because it doesnt matter if the table is deleted after the package stops.

thanks

0条回答
登录 后发表回答