Import and Export Data


            By using import and export data to import or export table or views.
Step 1:

Go to start menu and click Import And Export Data.


It shows a bellow window.


Step 2:


Click next and select Data Source, Server Name and DataBase


Step 3:


Click next and select a destination file


Step 4:


Click next and select a copy data from one or more tables or views


Step 5:


Click next and select source table or view


Step 6:


Click next and select file system in save SSIS package


Step 7:


Click next and give file name and file path


Step 8:


Click next


Step 9:


Click finish


Step 10:


After success just close this window and open import table or view


Comments

Popular Posts

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS