waiseekweng.wordpress.com
Running SSIS package in a database scheduler
Copy excel file/ csv file into the table daily repetitiously. Below is the guide to set the SSIS and use the generate package file in the job scheduler in MSSQL. SSIS Setup Tasks -> Import data…