SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Logging package execution.
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 12/27/2006 :  11:26:17  Show Profile
Has anybody had any luck logging package execution and errors in SSIS?

I have a package that executes just fine in debug mode, but fails as a job with the <sarcasm>incredibly useful</sarcasm> error message:
"Execution of job failed. See the history log for details."

So I check the job history and get other invaluable information, such as:
"The job failed. The Job was invoked by User blindman. The last step to run was step 1"

Ah, now all is clear. NOT!

So I try to enable logging to a text file to find out what is going on. Here is the crap that gets output:

OnError,HC1GEMSQLPRD1,NT AUTHORITY\SYSTEM,Transfer clas data,{DA16E07A-B8E8-450F-BDE6-EC244405D9D6},{1E59C18D-C24B-4709-9EC2-482302BD4A85},12/27/2006 11:19:05 AM,12/27/2006 11:19:05 AM,-1071611876,0x,The AcquireConnection method call to the connection manager "www.mydomain.edu.myserver.mydatabase" failed with error code 0xC0202009.


Seriously. I have had so many problems with SQL Server 2005, and come so close to irretrievably losing invaluable data on so many occasions, and had so much downtime, that I could NEVER recommend that any of my clients upgrade to this. In its implementation and documentation SQL Server 2005 is as bad as Oracle.

STAR SCHEMAS ARE NOT DATA WAREHOUSES!

Kristen
Test

United Kingdom
22403 Posts

Posted - 12/27/2006 :  15:24:53  Show Profile
I feel your pain ... but that's all I can contribute I'm afraid

Kristen
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 12/27/2006 :  15:32:34  Show Profile
I'm a noob with SSIS, so I can't really help either.

FWIW, I've already logged 2 bugs with Microsoft re: SQL2K5 - and we are hardly using it. I am a little bit concerned about the product too and am eagerly awaiting SP2. It seems like SP1 just enabled features that were initially promised for the RTM (mirroring, etc.), it didn't really provide a bunch of bug fixes like I had anticipated.

I guess my advice is to log a call with microsoft, that is really all that I have been doing whenever I run into stuff like this.



-ec

Edited by - eyechart on 12/27/2006 15:33:41
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000