DSXchange

Add $APT_DISABLE_COMBINATION to the job, set it to True and then rerun the job and repost the errors it reports.

As noted, it is having problems reading your input dataset. Does it exist? Does the structure in the job match what is actually in the dataset with that name?

Only certified for XP but have been known to be workable from Vista, so should as well from 7. You may very well be a pioneer there, let us know how it works out for you. The Business or Ultimate versions may help out with this.

No guarantees but it's an educated guess as to the problem. Let us know if it helps at all.

Not sure either, the messages you were getting didn't really make any sense for the situation you were describing. At least you got it sorted out.

Usually a problem with your field delimiters. How many columns total defined in the stage and which one is MN_OFC_NO? If it's not the last one, then you'll need to set that attribute as 'Replace' from it until the last column.

Sounds like you need to look into a Sequence job using the Start/End Loop stages and probably the User Variables Activity stage as well. That way you could build a delimited list of your source IDs and then send one at a time to a processing job inside the loop.

Sounds similar to an issue I had:

viewtopic.php?t=123862

So, other than what I posted which you've chosen to disregard, in other words? Then it seems to me that you should punt this over to your official support provider.

You need to understand that what that will get you is a conventional load, strictly transactional inserts rather than any kind of 'bulk' operation, which is why it will "work" with indexes and constraints in place.

The column is missing and the 'Missing Column' attribute for that column is set to 'Error'. If it is ok for it to be missing, change it to 'Replace'.

Argh, should have looked closer at the error message. Those DEFINE lines are not the issue, nor was it complaining about anything in your compiled transformer code but rather: Program "*DataStage*DSR_LOADSTRING": Line 333 We don't have access to these DataStage internal routines, but I thi...

Why ASAP? Where is anyone's motivation to do anything for you "ASAP" here? Sheesh. Play that game with your official support provider, not us. :evil: And you are not helping your cause by repeating posts and hijacking any other XML thread you can find. When you have an issue, start a new p...

There's no such thing as 'data purge' specific to DataStage. A quick google turned up this but again that's not specific to anything in particular.

Please stop posting in other people's threads and start your own.