dts error

Last Post 02 Jul 2004 07:35 AM by andy1. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
andy1
New Member
New Member

--
02 Jul 2004 07:35 AM

How to deal with this DTS error. It happens when I schedule the SQL Server DTS package through SQL Server agent. It runs successfully if I execute it from data transforamtion services folder.

The package suupose to drop and recreate the table and then load the data from a file.

Thanks!

*****************************************************************************************
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Drop table [Test].[dbo].[cusowner] Step DTSRun OnError: Drop table [Test].[dbo].[cusowner] Step, Error = -2147217887 (80040E21) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Drop table [Test].[dbo].[cusowner] Step DTSRun OnStart: Create Table [Test].[dbo].[cusowner] Step DTSRun OnError: Create Table [Test].[dbo].[cusowner] Step, Error = -2147217887 (80040E21) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) . The step failed.
*******************************************************************************************
You are not authorized to post a reply.

Acceptable Use Policy