Posted by ng on 01/26/06 10:24

Hi Scouser,

I've got a suggestion: Create a stored proc that does the count of the
records and then execute the DTS from the procedure, if the condition
is true.
Look at this message if you want to see how to execute the DTS-Package
from a stored procedure:
http://groups.google.de/group/borland.public.delphi.database.sqlservers/tree/browse_frm/thread/2ca55aa1eaff59b9/7b3094f55d5542cd?rnum=1&hl=de&q=Darren+Green+200006013&_done=%2Fgroup%2Fborland.public.delphi.database.sqlservers%2Fbrowse_frm%2Fthread%2F2ca55aa1eaff59b9%2F2bd62580101f38fe%3Flnk%3Dst%26q%3DDarren+Green+200006013%26rnum%3D1%26hl%3Dde%26#doc_2bd62580101f38fe

Michael
www.zankl-it.de

• Next in forum: Re: configuration/load balancing
• Prev in forum: Re: Joining tables in different databases
• Thread view: Re: Conditional execution of DTS package task

[Reply to this message]