SSIS Package creating XML
-
Hi All, Ok so I am hoping I can get some help here please? My situation is that we have three environments 2 are using sql server and 1 is using sql server clustered. We have a SSIS package that is used to create xml files which works perfectly in environment 1 and 2. However in environment 3 the using clustered sql the xml file generated is out of sequence. It's lists all odd numbered records first then all the even numbered ones. Everything between the environment is like for like so I cannot see why this is happening. Are there any steps or an approach I can use to see why this could be happening? Thanks KP
-
Hi All, Ok so I am hoping I can get some help here please? My situation is that we have three environments 2 are using sql server and 1 is using sql server clustered. We have a SSIS package that is used to create xml files which works perfectly in environment 1 and 2. However in environment 3 the using clustered sql the xml file generated is out of sequence. It's lists all odd numbered records first then all the even numbered ones. Everything between the environment is like for like so I cannot see why this is happening. Are there any steps or an approach I can use to see why this could be happening? Thanks KP
Member 13357915 wrote:
It's lists all odd numbered records first then all the even numbered ones.
Why is that a problem?
Member 13357915 wrote:
so I cannot see why this is happening.
Assuming ordering perhaps. If you are not explicitly ordering the records then you are assuming the ordering. There is no assurance of ordering. It might normally be ordering (default ordering) by the primary index and that might change with a cluster.