Posted by MC on 11/15/05 16:54

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" <nioannides@laiki.com> wrote in message
news:1132057983.407974.60410@f14g2000cwb.googlegroups.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
>

[Back to original message]