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

Web Programming guide – Inserting data using SQL data source controller

In developing web base system, retrieving and inserting data is a basic thing. As in ASP.NET, it makes development easy. As we're going to explore one of the control-SqlDataSource control which I have tested it out with a simple web application form name 'NewContract.aspx' in SCM test n error 2 project. Let's  start from the …

Continue reading Web Programming guide – Inserting data using SQL data source controller