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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-15 : 08:10:29
|
| Owen Geraghty writes "I've been trying to run jobs on a schedule. These mainly involve importing data, and backing up. Each of the jobs works when run, but when scheduled they fail. An error message from one such job is shown below. SQLServerAgent is set to automatic, and the log on information is correct. I'm using SQL Server 7 SP4 with Windows NT.... DTSRun: Executing... DTSRun OnStart: Delete from Table [OSIRIS].[dbo].[tbl_Status_Jobs] Step DTSRun OnError: Delete from Table [OSIRIS].[dbo].[tbl_Status_Jobs] Step, Error = -2147217887 (80040E21) Error string: The property 'Tag with column collation when possible' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: The property 'Tag with column collation when possible' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Error source: Microsoft OLE DB Provider for... Process Exit Code 1. The step failed.Thanks ever so much,Owen" |
|
|
|
|
|
schedules