Laura,

To set up a SQL Server Log Provider, do the following steps:

[font="System"]1. Open the package for which you want to configure logging in BIDS.

2. Select 'Logging...' from the SSIS menu.

3. Select 'SSIS log provider for SQL Server' from the Provider type drop-down box and click 'Add'.

4. Tick the checkbox on the newly-added line (to indicate that you want to use this new log provider).

5. Select a configuration - explanation below.

6. Choose the containers for which you want logging to be active.[/font]

The default location for SSIS logging using a SQL Server Log Provider is a table called dbo.sysdtslog90 in the msdb database, but you can choose any database as the logging repository. To do that you need to set up a Connection Manager for your chosen database and the dbo.sysdtslog90 table will be automatically created in that database. You then simply choose that database in the Configuration drop-down box.

(A more flexible option is to use Package Configurations to set your Connection Manager properties at runtime for example if you want to run the same package on multiple environments without having to edit the Connection Manager properties each time. You would then choose the name of the relevant package configuration in the Configuration drop-down box).

Have a look in Books Online under 'Implementing Logging in Packages' for more info.

HTH

Lempster