I have the following problem. I currently have to modify a .dtsx-Package which was originally created by a coworker who is not arounf anymore. This package contains some logic but above all it does the following:
- The Package contains some reference to xsd-files which provide a structure.
- Some XML-files are fetched and read based on the structure provided with the xsd-files.
- The process is supposed to write to several ADO destinations witch hold tables according to the data in the xsd-files.
- After the package retrieves and reads the xsd + xml files a merge join is applied and the data is supposed to be written to the database.
The whole thing looks something like this:
So the rest of the package is huge and it works fine. But for this one component I have had trouble for several days now. Here everything works fine, except for the Merge-Join node. normally if I open the editor I am always able to map the column names according to their names. In this case this very same window looks as follows:
As you can see there are no mapping possible as this dialog doesn't show any column names, so every time I try it nothing happens.
Any ideas? Note the very same procedure works throughout the entire package, it is only in this one task where it behaves kinda strange.