January 12, 2008 at 12:08 pm
Comments posted to this topic are about the item SQL Overview SSIS Package II - Retrieving SQL Error Log
David Bird
January 16, 2008 at 9:32 am
David,
Another great tutorial! I am eagerly anticipating Part 3 of your series.
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
July 8, 2011 at 9:47 am
Link to SQL_Overview_Part2.zip seems broken.
July 11, 2011 at 9:30 am
Try the last link to file listed under Resources: with a colon.
David Bird
July 11, 2011 at 2:05 pm
It works. Thanks a lot.
July 26, 2011 at 6:26 am
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?
July 26, 2011 at 11:25 am
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