Posted by nai on 11/15/05 14:33

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

• Next in forum: Re: Concatenating strings from different rows
• Prev in forum: Re: Concatenating strings from different rows
• Thread view: Re: DTS package design - Not allaowed link

[Reply to this message]