• thanks for the replies

    I have built a ssis package with a for each loop from a result set

    all working swimmingly

    thanks again