Sending email through store procedure

Database email setup Double click 'Databse Mail' to start setup Create mail configuration select as below key in the profile name and click 'Add' key in email address and the server ip address add the SMTP email address and server ip address click 'Next' click 'Finish'   Store Procedure Parse in the profile to be …

Continue reading Sending email through store procedure

Selecting data from MySql in MSSQL

Setup Link Server right click to add new linked server. Fill in all the appropriate details accordingly. Follow the database name in mysql to be use as data source over here. Provider string: DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=ip address;PORT=port number;DATABASE=mt4_demo;USER=username;PASSWORD=password;Option=3 test connection and save it.   after setup To query the data from the table …

Continue reading Selecting data from MySql in MSSQL

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