How to create and configure the Load Expenses package (Enterprise Manager)

How to create and configure the Load Expenses package (Enterprise Manager)

To create and configure the Load Expenses 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 Load Expenses.
   
   
4. Right-click the Data Transformation Services (DTS) design sheet, and then click Package Properties.
   
   
5. Click the Logging tab, and then clear the Fail package on first error check box.
   
   
6. Click the Advanced tab, select the Use transactions check box, and then clear the Commit on successful package completion check box.