Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
Data Transformation Services
DTS Package Designer
Scheduling Running Package
Monitoring SQL Connections
Monitor Locked Resources
SQL-EM Monitor Locks
Overall System Performance
Monitor Data Cache
Monitor Performance using DBCC
use SQL-EM to Database Size
Monitor Databases using DBCC
Maintaining Database Statistics
Database Maintenance Plan wizard
Running a package in SQL-Server
This is an example of a completed package.
To execute a package, select Execute from the Package Menu.
The executing package screen shows the status of each step in the package as it executes.
The screen shows you which steps are completed successfully. If the step is not completed successfully, the screen will show an error message.
If there are errors, you can double-click on the step in error to see a more detailed message.
The actual error message on the screen will vary depending on what went wrong with the package.