Running SSIS package in a database scheduler — Seek Weng


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 […]

via Running SSIS package in a database scheduler — Seek Weng

Advertisements