The ExcelFiles connector offers the most natural way to access Excel files. Simply use Excel Data Provider objects to connect and access data just as you would access any traditional database.
The ExcelFile, under the Authentication section, must be set to a valid Excel file.
Tip: The Excel connector automatically limit the size of character based columns (nvarchar) to 2000 characters.
If more characters are required, specify the length of characters in connection string by adding Other=“DefaultColumnSize=nnnnn”; where nnnnn is the required length.
||The Valid Path or the Location where the excel file exists.|
To check for the Data Migrations-
Add a new connection in Data Governor as shown.
Using the connection string parameters created, verify the connection using the Verify Connection option in Data Governor. Once the connection is verified, insert the connection using the Insert option.
Create a job using the Add a Job option in Data Governor. Add a data migration task to the job.
Create a new task by right clicking job list and then the Add a New Task option. If you want to edit an existing task use the Edit Task option.
Choose a Data Migration Task.
Choose the source and the destination for the migration of data. Name the task.
Choose the Tables or the data that need to be migrated from the source to the destination. You can choose to copy all tables from the source by checking the Copy All Tables checkbox. Save the task.
Execute the job. Check for results and the details of the data migrated in Execution History.