Import from SQL Sever

How to Import from SQL Server?

· This task helps to import data from a table in another database using SQL server connection string .

· Right click on the Import from SQL Server Task and select Details.

· Select SQL Server Parameters tab to add parameters.

· Click on Edit flag and give SQL connection string in the textarea field.

· Save the details.

· Click on Add flag in the Task Parameters tab and give Table Name, Insert Type and SQL query.

· Save after filled the details and close the tab.

· Run the task.