SQL Overview SSIS Package II - Retrieving SQL Error Log

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » SQL Overview SSIS Package II - Retrieving SQL...

SQL Overview SSIS Package II - Retrieving SQL Error Log

Rate Topic

Display Mode

Topic Options

Author

Message

David Bird

Posted Saturday, January 12, 2008 12:08 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:24 AM
Points: 187, Visits: 1,068

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

David Bird

My PC Quick Reference Guide

Post #442143

Key DBA

Posted Wednesday, January 16, 2008 9:32 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 26, 2009 3:02 PM
Points: 515, Visits: 655

David,

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

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

Post #443781

Pei Zhu-415513

Posted Friday, July 8, 2011 9:47 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:58 AM
Points: 1,251, Visits: 3,331

Link to SQL_Overview_Part2.zip seems broken.

Post #1139013

David Bird

Posted Monday, July 11, 2011 9:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:24 AM
Points: 187, Visits: 1,068

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

David Bird

My PC Quick Reference Guide

Post #1139837

Pei Zhu-415513

Posted Monday, July 11, 2011 2:05 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:58 AM
Points: 1,251, Visits: 3,331

It works. Thanks a lot.

Post #1140010

zheng.xu

Posted Tuesday, July 26, 2011 6:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 22, 2014 5:40 AM
Points: 5, Visits: 186

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?

Post #1148239

David Bird

Posted Tuesday, July 26, 2011 11:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:24 AM
Points: 187, Visits: 1,068

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

My PC Quick Reference Guide

Post #1148522

« Prev Topic | Next Topic »

Permissions