|
|
Posted by MC on 11/15/05 13:22
Try adding the text file target and transformation and then putting the 'on
success'. Or, in another words, define the next task and then do try the
precedence. If this doesnt help, please provide more info.
MC
"nai" <nioannides@laiki.com> wrote in message
news:1132052395.069551.53780@z14g2000cwz.googlegroups.com...
> Hi all,
> I'm fairly new to this...
>
> I't trying to design a DTS package on SQL Server 2000`, which will
> connect to the server, export some table date into a .txt file (based
> on a select statement) and then delete the data from the table (based
> on a delete statement) upon successful completion of the export.
> So far so good..
>
> Now, upon the successful deleteion, I want to export some more data and
> then (upon the successful export) to delete the data. I want to repeat
> this process approx. 10 times.
> Though, when I try to link the deletion to the new export on success, I
> get the message: "Defining the precedences between the selected items
> is not valid."
>
> Any idea on how I can accomplish what I want to do?
>
>
> thanks a lot
>
Navigation:
[Reply to this message]
|