DTS package design - Not allaowed link

[nai]

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

[MC]

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" <ni********@laiki.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.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

[nai]

Thanks for the prompt reply.
I had already tried this..

Connection to server:
Microsoft OLE Provider for SQL

Transform data task properties
SELECT * FROM UAF_REQUESTS
WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
AND UAF_REQUESTS.RESPONSECODE = 'OK'

Export
to Text File, location F:\Backups\U_REQ.txt

ON SUCCESS

DELETE FROM UAF_REQUESTS
WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
AND UAF_REQUESTS.RESPONSECODE = 'OK'

--- Then I created another export to txt file

Selected the export object and the delete one, and tried to connect
them on success. The error message is the one mentioned in my first
email.

Please let me know if any other details would be helpful.
thanks

[MC]

I've sent you an email since i can do a package you described. Perhaps I
misunderstood or theres a difference in sequence or something. LMK.

MC
"nai" <ni********@laiki.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Thanks for the prompt reply.
I had already tried this..

Connection to server:
Microsoft OLE Provider for SQL

Transform data task properties
SELECT * FROM UAF_REQUESTS
WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
AND UAF_REQUESTS.RESPONSECODE = 'OK'

Export
to Text File, location F:\Backups\U_REQ.txt

ON SUCCESS

DELETE FROM UAF_REQUESTS
WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
AND UAF_REQUESTS.RESPONSECODE = 'OK'

--- Then I created another export to txt file

Selected the export object and the delete one, and tried to connect
them on success. The error message is the one mentioned in my first
email.

Please let me know if any other details would be helpful.
thanks