1.

What are the components that would be used to send data from the access database to the SQL database on the off chance?

Answer»

We will be using the following three components:

  • ONE OLE DB Source
  • Information CONVERSION Change
  • One SQL Server Goal
    OLE DB source is used to get information from the Access database source. Information conversion change is used in case of any datatype ANOMALY due to data contrast between source and destination databases. SQL Server Goal is utilized when we have the bundle run from the same machine and our database server is PUT on at the off chance. It is used for improving the SQL goal.


Discussion

No Comment Found

Related InterviewSolutions