DSXchange

You should have migrated the SDKSequences hashed file from the old project to the new one so the sequence values were retained, sounds like you can still do that now. That or you need to connect to each project on the new server that leverages that routine and use the update code you posted to reset...

Or you could possibly send that data to a separate target.

While you can use job parameters in the 'Before SQL' area, you cannot use data generated in the job. That sql runs when the connection is made - before the job even starts to process data.

Looks to me like yet another example of overflow, as in your value is too large to be represented in an Integer.

Correct, the environment variable noted will correct that issue.

Filesystem permissions, down the DSEngine & Project paths. Specifically the group permissions since your ids are in the same group as dsadm.

It is out there and has been discussed a number of times.

Look into the optional property "File name column". You may also need to add $APT_IMPORT_PATTERN_USES_FILESET to your job and set it to true but I would suggest trying it without it first.

I assume you mean "corrupted" here. And I feel like we came in the middle of a conversation. :? Start over. Tells us what exactly it is you are experiencing and the error(s) you get. I know you posted a link (which is good) but it would be helpful to know what you tried from it and what &q...

Check the Parallel Job Developer's Guide for the list of available functions. Perhaps ...

MonthDayFromDate()
WeekdayFromDate()
DaysInMonth()

Depending on how you are looking to solve this.

Permissions, I would assume.

As a guess, the project may have some manner of corruption in it and be a candidate for a REBUILD.

Ah... having dealt basically 100% with Oracle where I would always treat a DATE as a full Timestamp with explicit control over the time portion, that never really clicked for me.

Sorry for being especially dense tonight but why would you 'expect a Server job to behave this way'? I must be missing something fundamental here...

Nope, Convert() replaces a single character with another single character.

Done.

For the record, this was split from this topic.