SQL Overview SSIS Package II - Retrieving SQL Error Log

  • David Bird

    SSCarpal Tunnel

    Points: 4669

    Comments posted to this topic are about the item SQL Overview SSIS Package II - Retrieving SQL Error Log

    David Bird

  • Key DBA

    SSCertifiable

    Points: 6029

    David,

    Another great tutorial! I am eagerly anticipating Part 3 of your series.

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • Pei Zhu-415513

    Hall of Fame

    Points: 3689

    Link to SQL_Overview_Part2.zip seems broken.

  • David Bird

    SSCarpal Tunnel

    Points: 4669

    Try the last link to file listed under Resources: with a colon.

    David Bird

  • Pei Zhu-415513

    Hall of Fame

    Points: 3689

    It works. Thanks a lot.

  • zheng.xu

    SSC Rookie

    Points: 29

    Hi David,

    Tried your SSIS package. Brilliant idea. However, I got an error message ( or warning ... I am not quite sure since the package did deliver the result but in Excution Result window, I noticed there are few red marks...)

    [Execute SQL Task] Error: Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Task Get ErrorLog failed

    Progress: Executing query "-- Drop Temporary Tables

    IF OBJECT_ID('tempdb..#E...". - 50 percent complete

    Not quite sure what the reason behind this. The connect use DBA account. So, I guess there shouldn't be any previlidge issue. Any idea?

  • David Bird

    SSCarpal Tunnel

    Points: 4669

    Make sure the SQL Overview database is on the localhost using the default instance. Create the temp tables on the local host before opening the package.

    Make sure the variale Srvconn is set to localhost

    David Bird

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

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