title: SSIS Logging to SQL Server
body: <p>I am a novice to SSIS. I have created a package with few Sequence Containers and few Tasks within them. The package will be scheduled to run automatically and thus I want capture the run time errors and status like number of rows inserted/updated/deleted to my own logging table in the SQL database.</p>
  
  <p>I was thinking of using the SSIS Logging to SQL Server feature to log the entries to the default tables and then create a SQL Task to insert them into my own logging tables. Is that a good way to do it? Or do you suggest other better ways?</p>
  
  <p>Also I couldnot get the SSIS logging to work properly. I found an online blog 
  <a href="https://stackoverflow.com/questions/5772667/how-to-create-an-error-log-or-custom-error-log-within-an-ssis-package">How to create an error log or custom error log within an SSIS Package?</a> that describes the process to use SSIS logging to log entries to the SQL Server. However, unlike explained in the blog, </p>
  
  <p>I cannot see either the <code>dbo.sysssislog</code> or <code>dbo.sp_ssis_addlogentry</code> tables created in my SQL Server database. What must I be doing wrong? Here are the steps I followed -</p>
  
  <ol>
  <li>Went to SSIS Logging</li>
  <li>Selected Provider Type as SQL Server</li>
  <li>Added the OLEDB connection for Configuration</li>
  <li>Went to the Detail tabs on each sequence container and chose appropriate events</li>
  <li>Clicked "Save..."</li>
  <li>Provided the location and name for the XML file</li>
  <li>Saved the package and ran it.
  Still cannot see those ssis table or procedure in the database. I am using SQL 2008R2.</li>
  </ol>
  
  <p>Any suggestions and recommendations greatly appreciated.</p>
  
  <p>Thanks in advance. </p>