Posted by nai on 11/15/05 12:59

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

• Next in forum: Re: DTS package design - Not allaowed link
• Prev in forum: Re: SQL server connection problem
• Thread view: DTS package design - Not allaowed link

[Reply to this message]