parent/child text File Import

I have a file with a parent child records in the same file.

My game plan is to get it into a table recognize the parents and put them in the parent table and recognize the children and put them in the children table.

The problem I am having is the flat file import chokes on it because the column withs are different from line to line (parent / child).

Any thoughts or suggestions would be apprecaited.

Mardo

You'll need to import the data into the pipeline as a single wide column and then parse out the required values using a combination of the condistional split component and derived column component.

-Jamie

Parent Package Doesn't Recognize Child Settings

I have two issues:

I have a simple parent that uses an Execute Package Task to call a simple child package. The child package has a Data Flow that I disabled. When running the child package by itself, the data flow task is bypassed. When running the package via the parent the data flow task executes.

Second issue is when you disable the package configurations in the child, the parent doesn't recognize that it's diables and tries to load the configurations.

It's almost like there are some settings in a child that get ignored by the parent?

Anyone else experience this?

thx

My fault, pls ignore...