Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khermann
Starting Member
10 Posts |
 Posted - 2009-11-20 : 19:41:14
|
Hi,I have spent a lot of time getting this far and I'm baffled (baffled, i say!) at this error. Please help! and thank you in advance.I have dtsx files i exported from 2005 from Maintenance Plans.This example plan is very simple (i have others) for sake of argument - one task, one connection manager (Local Server Connection, as required by the Maintenance Plan 'Lite' version of SSIS), I'm just backing up a transaction log. I want to put this package on a new server, so I:1. Update dtsx file, and the single connection manager replacing old with new hostname. 2. Run dtutil -I on the dtsx file to generate a new GUID for the plan.3. Run dtutil /File ".\bkuptlogs.dtsx" /DestServer NewInstanceName /Copy SQL;"/Maintenance Plans/tlog backup"All three run without issue, even loading up the modified dtsx file in BIDS on the target system shows no problems on validation.Inspecting the SSMS Maintenance Plan objects all goes as expected, the plans are there, i can modify them, add a schedule (which adds a subplan agent job) , and so on.Executing the plan, or a subplan agent job, executes the intended flow and my tlogs are backed up wonderfully.The Agent job, however, reports failure on the Reporting Task: quote:
Error: 2009-11-20 16:30:03.34 Code: 0xC0024104 Source: Reporting Task for subplan-{EF945E56-0D0B-4686-8EB4-7B42AB60CAAC} Description: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error
I've tried this between builds 3239 and 4035, x86 , the symptom is consistent even when loading the plan back in to the server from whence it came. This initially led me to believe perhaps there is a disconnect (read: bug) when generating the new GUID, but so far I have not been able to find a clear indicator of how I can resolve the issue.Again, thank you in advance for your help!-k |
|
|
khermann
Starting Member
10 Posts |
Posted - 2009-12-09 : 20:33:11
|
| Never did get an answer on this, here or elsewhere, but had to move on with a workaround.I ended up disabling the reporting task in BIDS; this is the reporting task for the subplan container. After some time reviewing the logs this task generates its apparent they are not very helpful and I don't anticipate needing them |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-06-15 : 17:41:22
|
| anyone has a solution for this? |
|
|
|
|
|
|
|
|
Imported plan runs, but Agent Job reports failure