How to create and configure Add New Employees (Enterprise Manager)

How to create and configure Add New Employees (Enterprise Manager)

To create and configure the Add New Employees package

1. In the SQL Server Enterprise Manager console tree, right-click Data Transformation Services, and then click New Package.
   
   
2. On the Package menu, click Save.
   
   
3. In the Package name box, type Add New Employees, and in the Location list, click SQL Server.
   
   
4. Right-click the Data Transformation Services (DTS) design sheet, and then click Package Properties.
   
   
5. Click the Advanced tab, select the Use transactions check box, and then clear the Commit on successful package completion check box.
   
   
6. Click the Logging tab, and then under Error handling, clear the Fail package on first error check box.