DSXchange

That would typically be solved using the Java Transformer. You should be able to do an exact search here for that to get details.

IMHO you really should be installing something much more recent than the known 'chock full of issues' 8.0 release.

adams06 wrote:for more info see the log file.

What's in the log?

Actually that is an ordinal date where the last three are the number of days into the year, which some people call a Julian date but really isn't as that would be the number of days from 4713 BCE January 1 @ noon GMT. Use %ddd in your StringToDate() date format to indicate "day of year" as...

What are you considering "junk" or "special" characters? You probably just have a characterset issue.

I don't understand why you could consider setting any APT variable like this at the Project level. This falls into a class meant to be used at the job level on an "as needed" case-by-case basic. At least that's my understanding.

Don't apologize, just don't do it.

Split to your own topic.

That's... odd.

Googling around it seems that what CC does depends on the source system. In your case (an example would have helped in your first post) it looks like you need to take the first two characters, subtract 1 from them and stick them back on.

You need to start your own topic when you have an issue, not jump on the end of a four year-old one and say you have "the same issue". Detail for us here the issues you are having.

ps. Split from this topic if anyone wants to see the previous conversation.

Thanks for that. Added some

Pretty sure I recall reading here that any job with 'default' purge settings would now automatically inherit any changes to the Project level defaults. Ones where that had been 'overridden' would not. I recall being surprised by the posting of that information... let me see if I can turn it up... Si...

Actually select something to pass through. Do you have an equivalent of the Oracle or DB2 'dual' table in SQL Server?

Your issues with the Command stage imply to me that it just does not support the functionality you need, i.e. handling a dynamically generated command. And right now I have no access to my documentation so can't help with specifics on using that Utility function. Did you try an exact search for that...

Your issue = your post. Splitted.

You'd need to show us how you built the string in the transformer. By the time it hits the command stage it shouldn't have any 'variables' in it at all, it should just be a string where you have substituted any variable with the actual value needed. You should end up with a string that looks exactly...

Applying the auto-purge settings in administrator now will not help obviously.. Are you certain about that? While in the past that was true - Admin changes only affected new jobs - pretty sure I recall them changing that behavior. It would be worth a quick check IMHO unless you've already done that.