Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Morning Review not working on SQL 2008 Servers Expand / Collapse
Author
Message
Posted Thursday, January 13, 2011 11:01 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 1:33 PM
Points: 37, Visits: 264
Morning Review not working on SQL 2008 Servers.

I've been using the "Morning Review" at every job I have since I discovered it. Love it and it's so useful. I am having an issue though getting it to work with SQL Server 2008. Is there something I need to tweek in the SSIS packages or on the 2008 servers to get it to work? I love it and really want to continue to use it as I migrate from 2000 and 2005 servers to 2008.


Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
Post #1047462
Posted Thursday, January 13, 2011 11:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:36 PM
Points: 6,593, Visits: 8,874
If this is the one I'm thinking about, then I use it also. Do you have a table names "SSIS_Errors"? Check that out for the error message being returned for those servers. I ran into the same problem, and I remember needing to change the width of some columns to handle expanded widths in SQL 2008. I just don't remember which ones we needed to modify.

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1047482
Posted Thursday, January 13, 2011 12:09 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 1:33 PM
Points: 37, Visits: 264
Thanks for responding Wayne! Here are the errors I'm seeing:


component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

One or more component failed validation.

SSIS Error Code
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

There were errors during task validation.

component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

Did you receive any of these on your 2008 server?




Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
Post #1047504
Posted Thursday, January 13, 2011 12:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:36 PM
Points: 6,593, Visits: 8,874
Are you specifying the instance name in the servername fields?
If you're using an alias - is it set up with the instance name?

That error sounds like something we saw dealing with connecting to servers, but I honestly don't remember is that was with the morning review stuff, or in general.


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1047523
Posted Thursday, January 13, 2011 12:53 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 1:33 PM
Points: 37, Visits: 264
yes i've tried both the server name and the named instance, neither works

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
Post #1047534
Posted Thursday, January 13, 2011 12:59 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:36 PM
Points: 6,593, Visits: 8,874
At this point, I'm not sure. How about posting everything in the SSIS_Errors table for the last run only? There might be other messages in there that will give us a clue to it.

You can connect to these servers remotely?


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1047537
Posted Thursday, January 13, 2011 1:39 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 1:33 PM
Points: 37, Visits: 264
those messages above are all I have in ssi_errors.

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
Post #1047554
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse