• Jack's got some good questions here. You have not told us much about what you are doing.

    In general, you'll need 2 data flows. One to load the parent data and one to load the child data. Inside the child data flow, you'll want to use a lookup transformations to find the parent id.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden