You need to create two different data flow tasks. The first one will have the connection to the source, do all the data manipulations and then load data to the header table.
The 2nd data flow task will load data to the detail table.
If required you will have to repeat the same data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.