asked on

Move SYSSSISLOG table

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!

25112

"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/

fredsmullin

ASKER

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.

ASKER CERTIFIED SOLUTION

25112

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fredsmullin

ASKER

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.

fredsmullin

ASKER

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.