?
Solved

Move SYSSSISLOG table

Posted on 2011-10-31
5
Medium Priority
?
2,174 Views
Last Modified: 2012-05-12
I'm not an expert in SSiS.  I have a 2008 R2 SQL Server and the Microsoft BPA recommends moving the SYSSSISLOG table from its default database, MSDB, to its own database.  However, I cannot find a "hold your hand" example of how to move it after searching for a few hours now.

Any tips would be appreciated!
0
Comment
Question by:fredsmullin
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:25112
ID: 37060411
"That table is pointed at using a Connection Manager. Simply change the server & database that that Connection Manager is pointing to."

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e02f7864-702e-4075-b474-8d7758c8c629/
0
 

Author Comment

by:fredsmullin
ID: 37060675
Thanks for the link.  I found that one earlier and tried to decipher the connection manager, but I must be dense when it comes to the connection manager.  I have not found how to configure the connection manager to accomplish this.  The server in question is being accessed by an ASP.NET application.  Do I need to modify the web.config?

Thanks for your tips.
0
 
LVL 5

Accepted Solution

by:
25112 earned 1000 total points
ID: 37061331
sure.. this is how a connection manager looks like the attached..

see a small intro at http://dataintegrity.wordpress.com/2009/09/21/ssisintr/

you have to turn on the option "SSIS log provider for SQL Server" for logging" for logging to happen. In the connection manager for logging, give another database name and the SYSSSISLOG will written to that database.
CM.bmp
0
 

Author Comment

by:fredsmullin
ID: 37064595
Thanks for providing a screenshot.  I guess this is my first problem.  I cannot find any method of launching the connection manager.  I've searched both server and clients for a way to pop up the screen you provided.  Maybe connection manager was not installed?  My work location blocks wordpress.com blogs (unfortunately) and so I'll have to check out your link from home tonight.
0
 

Author Comment

by:fredsmullin
ID: 37072561
Thanks again for your input.  I'm going to accept your answer as the solution after finding the following Microsoft page:

http://msdn.microsoft.com/en-us/library/dd299429(v=sql.100).aspx

I was trying to comply with the Best Practices Analyzer, but I have confirmed we're not using this feature.  At least I now understand the connection manager and where it comes from.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question