Error in scheduled back up

I've been pulling my hair over this message in my daily backup log...
I found an article for this error message in knowledge base (274743), and it
has something to do with SMS database. But we do not use SMS. So, I don't
know how to solve this problem...
This error moves around every day... sometimes Master doesn't get backed up
, sometimes model...
I'm not 100% sure, but maybe it started after I started to run optimization
job...
I'd appreciate any help on this... Thank you!
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023: [Microsoft]&#
91;ODBC SQL Server Driver][SQL Server]Backup, CHECKALLOC, bulk copy, SEL
ECT INTO, and file manipulation (such as CREATE FILE) operations on a databa
se must be serialized. Reissue the statemen
t after the current backup, CHECKALLOC, or file manipulation operation is co
mpleted.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore
operation terminating abnormally.The error is from some other operation such as those listed,
was running when you executed the backup.
The optimizations option does have some activities that
would prohibit a backup at the same time as when that part
of the plan is run - e.g. the option to remove unused space
just does a dbcc shrinkdatabase and you can't run this and a
backup at the same time.
The best way to solve it is to just write your own jobs to
perform your maintenance. This allows a lot more control,
flexibility with your database maintenance.
-Sue
On Mon, 29 Mar 2004 15:26:08 -0800, "Amy Miller"
<amiller1@.sonomacourt.org> wrote:

>I've been pulling my hair over this message in my daily backup log...
>I found an article for this error message in knowledge base (274743), and i
t has something to do with SMS database. But we do not use SMS. So, I don'
t know how to solve this problem...
>This error moves around every day... sometimes Master doesn't get backed u
p, sometimes model...
>I'm not 100% sure, but maybe it started after I started to run optimization
job...
>I'd appreciate any help on this... Thank you!
>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023: [Microsoft][ODBC
SQL Server Driver][SQL Server]Backup, CHECKALLOC, bulk copy, SELECT INTO, and f
ile manipulation (such as CREATE FILE) operations on a database must be serialized.
Reissue the stateme
nt after the current backup, CHECKALLOC, or file manipulation operation is completed.[color
=darkred]
>[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operat
ion terminating abnormally.[/color]

Error in execute a scheduled package

I'm learning SSIS and ran into this error...

I have a package that has its source as an Oracle DB on another server. This package will feed data from that source to a SQL Server 2005 DB. So far, the package works fine if it is executed manually even in SQL Mgmt Studio. It's only failed when I tried it as a scheduled job. I guess I need to do "Package Configurations" which includes the UserID and password for accessing Oracle DB ... but I don't know how. Please help.

Regards,

dnncpt

-

Here is the error message:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/08/2007 09:49:00,DataFeed,Error,0,<MyDBServer>,DataFeed,(Job outcome),,The job failed. The Job was invoked by Schedule 8 (Schedule DataFeed Grant Tables). The last step to run was step 1 (DataFeed Grant Tables).,00:00:02,0,0,,,,0
05/08/2007 09:49:00,DataFeed,Error,1,<MyDBServer>,DataFeed,DataFeed Grant Tables,,Executed as user: <MyDBServer>\SYSTEM. ....3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:49:00 AM Error: 2007-05-08 09:49:00.81 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-05-08 09:49:01.86 Code: 0xC0202009 Source: AWARDS Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: null password given; logon denied". End Error Error: 2007-05-08 09:49:01.86 Code: 0xC020801C Source: Feed data t... The package execution fa... The step failed.,00:00:02,0,0,,,,0

For the error, I think this link may be the answer:

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b904800

So the protection level is the reason.

I really love the Microsoft technologies but if MS could provide such a nice software like SQL Server and SSIS why its tech teams don't go a further step as to provide a good how-to document for each application. This could benefit for both MS and its customers. (hope Mr. Gates or Mr. Ballmer read this)

Regards,

dnncpt