> Error Source: Microsoft Data Transformation Services (DTS) package
> error Description: Task 'Delete from Table [POS].[dbo].[PACKAGE]

> Oracle 10 import DTS package with 11 tasks, 1 task per table.
> Yesterday I added more tasks after this package has been working for a
> month. There are 2 tasks (Delete from existing table, transform
> Oracle to SQL Svr table), 2 connections (Oracle, SQL Svr 2k) and 1
> workflow "on completion" after the delete.
>
> Flow is Delete from POS.dbo.PACKAGE
> upon completion
> Oracle connection
> transform Oracle to SS
> SQL Server connection
> Message text is
> Package Error:
> Error Source: Microsoft Data Transformation Services (DTS) package
> error Description: Task 'Delete from Table [POS].[dbo].[PACKAGE]
> I have done disconnected edits on some of the tasks. all 10 of the
> other 'Delete from Table...' tasks give the error when I try to open
> them. Is there a sync function that I need to do after a disconnected
> edit? or a re-connect process?
>
> What can I try to fix this error?
>