I have two hugh data in excel one has the parents and the other has the children. The tables are already in the db. How would I load these with SSIS. There are parentID in the child table as a foreign key how would these be updated.
Create two data flows with a Success constraint between them. Use the first data flow for your Parent table; create an Excel Source and an Ole DB Destination and load the data from Excel to SQL Server. Do the same for the Child table on the second data flow. I recommend using a Lookup Component (or Error Redirection) on the Child data flow to make sure your package doesn't blow up if you violate the FK constraint.