Microsoft Office Tutorials and References
In Depth Information
Control Flow Items (for example, Bulk Insert Task, to copy data from file to database; Data
Flow Task, to move data from source to destination while performing ETL; Execute SQL
Task, to execute SQL queries; Send Mail Task, to send email; and so on).
Maintenance Plan Tasks (for example, Back Up Database Task, to back up source database
to destinations files or tapes; Execute T-SQL Statement Task, to run T-SQL scripts; Notify
Operator Task, to notify SQL Server Agent operator; and so on).
Let’s see how to import data from a system and export it to another system. First launch the Import And Export
Wizard from the Solution Explorer as shown in Figure 1-16 . Then right-click on SSIS Packages and select the SSIS
Import And Export Wizard option.
Figure 1-16. Using the SSIS Import and Export Wizard
■ another way to access the import and export Wizard is from
C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTSWizard.exe .
Here are the steps to import from a source to a destination:
Click Next on the Welcome screen.
From the Choose a Data Source menu item, you can select various options, including Flat
File Source. Select “SQL Server Native Client 11.0” in this case.
Choose the available server names from the drop-down menu, or enter the name you prefer.
Search JabSto ::