Admin database

Developer
Sep 23, 2009 at 1:05 AM

Ben,

What is the Admin database?

It is not in the project but used in ETL connection strings and for the reports.

I see it on your machine in the video demo.

Is this the SSIS raw log file?

Thanks

Phil

Coordinator
Sep 23, 2009 at 4:19 PM

This is the DB I setup for my SSIS packages to log to. You can put it anywhere you like however for this project I created an 'Admin' database specifically for logging. Here are the steps you'll need to set it up. Please let me know if you have any issues...

1. Create a DB named 'Admin' on whichever server you would like for your SSIS packages to log

2. Modify the connection strings for this data source inside the SSISEventlLogETL.dtsConfig file (found in the _Config solution folder) to point to your server.