Post reply

Morning Review not working on SQL 2008 Servers

  • January 13, 2011 at 11:01 am

    #232203

    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

  • January 13, 2011 at 11:51 am

    #1273209

    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
    Author - SQL Server T-SQL Recipes

    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • January 13, 2011 at 12:09 pm

    #1273228

    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

  • January 13, 2011 at 12:43 pm

    #1273243

    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
    Author - SQL Server T-SQL Recipes

    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • January 13, 2011 at 12:54 pm

    #1273252

    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

  • January 13, 2011 at 12:59 pm

    #1273254

    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
    Author - SQL Server T-SQL Recipes

    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • January 13, 2011 at 1:39 pm

    #1273269

    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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply