First, you will need to enable DTS on your SQL Server:1) Go to Control Panel > Administrative Tools > Component Services:
3) Now, goto the Security tab and set the following:
4) Click 'OK'. You will get a MSDTC Service pop-up message that says that the service will be stopped and restarted.Click on 'Yes'.
The SQL Server Import and Export Wizard provides the simplest method of copying data between data sources and of constructing basic packages. For more information about the wizard, see SQL Server Import and Export Wizard.
For a video that demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet, see Exporting SQL Server Data to Excel (SQL Server Video).
On the Start menu, point to All Programs, point toMicrosoft SQL Server , and then click Import and Export Data.
In SQL Server Data Tools (SSDT), right-click the SSIS Packages folder, and then click SSISImport and Export Wizard.
In SQL Server Data Tools (SSDT), on the Project menu, click SSISImport and Export Wizard.
In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.
In a command prompt window, run DTSWizard.exe, located in C:\Program Files\Microsoft SQL Server\100\DTS\Binn.