SQLServerCentral / Discuss Content Posted by David Bird / Article Discussions / Article Discussions by Author / SQL Overview SSIS Package II - Retrieving SQL Error Log / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:03:04 GMT20RE: SQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxMake 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 localhostTue, 26 Jul 2011 11:25:00 GMTDavid BirdRE: SQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxHi 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...)[quote][i][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.[/i][i]Task Get ErrorLog failed[/i][i]Progress: Executing query "-- Drop Temporary Tables IF OBJECT_ID('tempdb..#E...". - 50 percent complete[/i][/quote]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?Tue, 26 Jul 2011 06:26:11 GMTzheng.xuRE: SQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxIt works. Thanks a lot.Mon, 11 Jul 2011 14:05:06 GMTPei Zhu-415513RE: SQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxTry the last link to file listed under Resources: with a colon. Mon, 11 Jul 2011 09:30:20 GMTDavid BirdRE: SQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxLink to SQL_Overview_Part2.zip seems broken.Fri, 08 Jul 2011 09:47:36 GMTPei Zhu-415513RE: SQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxDavid,Another great tutorial! I am eagerly anticipating Part 3 of your series.Wed, 16 Jan 2008 09:32:39 GMTKey DBASQL Overview SSIS Package II - Retrieving SQL Error Loghttp://www.sqlservercentral.com/Forums/Topic442143-283-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Integration+Services/61714/">SQL Overview SSIS Package II - Retrieving SQL Error Log</A>[/B]Sat, 12 Jan 2008 12:08:25 GMTDavid Bird