Setup Link Server
test connection and save it.
To query the data from the table
select * FROM OPENQUERY(MT4DBDEMONew, 'SELECT * FROM mt4_trades')
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.
select ‘Flat file source’
Select the file, change text qualifier to ‘ ” ‘, uncheck the check box if first row is data
Specify the database server name, type of authentication and database name
assign the destination table where data copy into. Click ‘Edit Mapping’ to set the mapping column
map the column in csv with the column in the table
Only Enterprise version allow to save package (Express version cannot). check the Save SSIS package.
specify the package name and click ‘Next’
Database Job Scheduler
Create a new job under SQL Server Agent
Set the step to execute the package
set the package file to be executed
Job done!! you can test it before leave it for everyday process.
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.