Hello,
First, pardon my ignorance. I am a core system admin at a large financial institution. I am not a formal SSIS developer. I have, however, worked with SQL for a long time and trained myself in SSIS. If my question is not clear, it is of my own ignorance. Any advice is appreciated. This audience is very skilled!
I will describe the need first for better understanding
Data from an outside party needs to be ingested into data "lake", for lack of better term.
Data is in the form of applications completed by borrowers. As such there are many leaf objects to this set.
The data arrives in the form of XML. The target is SQL server
Using Microsoft SQL Server Data Tools for Visual Studio 2017 to craft the logic
First step was a construct to strip the namespace from the XML files
Using the XML I created the equivalent of the app in a SQL server database. 105 tables
I have completed the receiving schema. I have 105 packages. I have ingested apps manually to test.
Now I believe it may be appropriate to use sequence container to parse the application XML files one at a time. Here lies the question. Is this the best way to proceed?
I appreciate any insight and again, I apologize again for my ignorance.
Have a great day, or evening.
Jim