Microsoft Office Tutorials and References
In Depth Information
Control Flow
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 .
Note
Here are the steps to import from a source to a destination:
1.
Click Next on the Welcome screen.
2.
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.
3.
Choose the available server names from the drop-down menu, or enter the name you prefer.
 
 
Search JabSto ::




Custom Search