DSXchange

Sounds like a job for the DaysSinceFromDate function.

Wondering... 6 or 7 thousand out of how many?

Still think it has something to do with your locale setting or something of that nature, whatever OConv uses to determine what day your week starts on. 2014-10-01 was a Wednesday, btw, hence the 3 or 4 depending on your week starting on Monday or Sunday. Clarify something, please - what is the diffe...

Yikes. Looks like massive overkill just to get the day of the week but I guess it was meant to be generic and one size fits all. Still. Where's the argument handling? I don't see any mention of Arg1 or Arg2, guessing "date" is Arg1 but no clue where the "D" you were passing in go...

Not aware of any "ToChar" function so it must be something unique to your site... what is it actually using inside it? Off the top of my head there are settings (a setting?) that controls what day of the week is considered day 1, Sunday or Monday... you may be running afoul of that. LOCALE...

This is about updates but thought it might help get you a starting point and/or methodology.

OK. Rather than load both / everything and then go back and delete the ones you didn't really want, why not just load the ones you do want and ignore the rest? Seem like that would be a simple matter of making sure the records are sorted appropriately and then using a Remove Duplicates stage... unle...

Which XML stage are you using? The advice posted was for the 'new' stage while you mentioned the XML Input stage in your first post.

What kind of condition? What you want to do isn't directly possible as far as I know - either the After SQL runs without error and your job succeeds or it "fails" and your job aborts. You may need to break it out as a separate step in the Sequence, run after the job completes... perhaps ca...

There's a specific forum for things like this... moved.

How about some details... This "old" record, it is already there when you load the new one? If so, will there only ever be one old record in the table when you insert a new version? I'm asking because it sounds like you may be able to use the Delete then Insert write mode property: Delete ...

Microsoft's "dot net" framework is a Windows product, which shouldn't be surprising considering it is from Microsoft. So no clue how you are getting that error if you have the correct binaries. Seems like time to check in with support.

Wild guess - you are attempting to install the wrong version, i.e. one for Windows.