You could use the Bulk Insert task for this.

- Point the Destination Connection properties at your SQL landing pad.

- Create a new file connection manager for your source. These...

How have you configured the child package?

One of the limitations of calling the child package from the parent package using the Execute Package Task is that you can't...

Are the column names different each time or is the number of columns differenct each time?

If the names are different then set the column heading names in the connection manager...

You can use expressions in the precedence constraints to read the value of the variable and split the control flow depending on the variable's value.

Format for expression:

(@VariableName)=="Y"

Sounds like an issue with the configuration of the connection manager.

Have you defined all of the columns in the advanced tab of the Flat File Connection Manager Editior?

Fixed this issue now by changing the SQLSourceType from Direct Input to Variable.