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 […]
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
Starting to play with the numbers app that comes with my mac, and after doing my spreadsheet, pretty much the same as excel so far, i want to share it and the standard being xls file, I figured how to do that. Go to file and select the export to => Excel. The rest is […]
This is the excerpt for your very first post.
via Keep Your Business’ Database Performing at its Best — Database Replication
In this blog, I am going to show you how easy to integrate Salesforce to .NET applications using Web Services SOAP API. You can perform DML operation of salesforce objects from .NET applications using web methods. In this example, I am going to show how to pull leads from Salesforce and insert into SQL server […]
In one of our previous blogs displaying account list in a Modal Dialogue box using Lightning Components was discussed.In this blog I will extend Creating a Modal Dialog box using Lightning Design System – Lightning Component by implementing security to it. Client is always under the control of attacker hence all access control enforcement must happen at […]
When and why? We wrote yesterday about the GitEnt-Scm.com shutdown due on April 30th, 2016. Now the issue you would be facing is: how to migrate somewhere else? Although StackOverflow already contains over 800 response threads when asking this question we thought that giving a practical example based on a real-life GitEnt repository would allow […]
