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

SQL Overview SSIS Package II - Retrieving SQL Error Log Expand / Collapse
Author
Message
Posted Saturday, January 12, 2008 12:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 7:43 AM
Points: 184, Visits: 1,007
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
Posted Wednesday, January 16, 2008 9:32 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr 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
Posted Friday, July 8, 2011 9:47 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 1,193, Visits: 3,152
Link to SQL_Overview_Part2.zip seems broken.
Post #1139013
Posted Monday, July 11, 2011 9:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 7:43 AM
Points: 184, Visits: 1,007
Try the last link to file listed under Resources: with a colon.


David Bird

My PC Quick Reference Guide
Post #1139837
Posted Monday, July 11, 2011 2:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 1,193, Visits: 3,152
It works. Thanks a lot.
Post #1140010
Posted Tuesday, July 26, 2011 6:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:46 AM
Points: 5, Visits: 174
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
Posted Tuesday, July 26, 2011 11:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 7:43 AM
Points: 184, Visits: 1,007
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 »

Add to briefcase

Permissions Expand / Collapse