SQL Overview SSIS Package II - Retrieving SQL Error Log

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

    David Bird

  • David,

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

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

  • Link to SQL_Overview_Part2.zip seems broken.

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

    David Bird

  • It works. Thanks a lot.

  • 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?

  • 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 6 (of 6 total)

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