We have 3 environments which are identical in nature and there are SSIS packages on them that create XML files which have a sequential record structure in them i.e. Rec 1, Rec 2, Rec 3 etc. Everything works as expected.
Now we have recently introduced a 4th environment whereby we are using SQL clustering. We installed the SSIS Packages (had to change the config file to add a servername of the other SQL Server) and the package runs ok.
However we find that all XMLs produced have records that are out of sequence i.e. Rec1, Rec3, Rec5, Rec2, Rec4, Rec6, We migrated everything like for like. Is there something in SSIS that when run in a clustered environment would cause this behaviour?
At a Complete loss with this one.