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 client 'Next' select 'Flat file source' Select the file, change text qualifier to ' " ', uncheck the check …

Continue reading Running SSIS package in a database scheduler