DSXchange

Sounds like you should make your surrogate key columns larger in your tables. How are they defined now?

That's completely up to you, your requirements and your job design, it seems to me.

Then you're not doing a bulk load, for whatever that is worth, because there is a specific stage for that.

Or download Chuck Smith's tool from his website that pulls all that information from the dsx for you. I've found it quite handy and redirect the output to a table so it becomes queryable.

I deleted your duplicate post on this exact same subject you created in the General forum. Please refrain from creating duplicate topics, it is highly frowned on here.

What's your target stage? That will answer the question.

:idea: A couple of suggestions, one of which you've already been given and seem to be ignoring... 1. Posting in ALL CAPS is considered to be SHOUTING so please don't do that. Unless you feel the need to shout, of course. 2. Don't put multiple subjects in the same post, keep them on a one-to-one basi...

If you've read other posts on the UNIX kill here, you'd see we never recommend using that kill -9 out of the gate. It should be your last resort.

Still, it's where they should start.

In pondering this more, while I still wouldn't advise this as the proper solution it would certainly be an interesting nut to crack. At a very high level, you could build a process that basically runs constantly and queries the repository for newly running jobs. Once it finds one, drop it into an ar...

It used to be part of the Manager but since that has gone away it should have been folded into the Designer. From what I recall it (the icon) looks like a flask or chemistry set beaker, should be there somewhere.

Yah, ASCII Art here can be a little challenging as the forum software automagically removes whitespace from everything that is not wrapped in code tags. So what you need to do is use the code tags and then liberally Preview what your output is going to look like in order to get it right. It won't li...

But i am not able to add it again via the administrator it showing message already exists. In Administrator no variable in userdefined. where can i see the above environment variable othere than administrator and how can insert? Why not just look a little closer? Open up all of the branches in the ...

Or perhap compile or force compile it again before retrying the export.

OK... then don't bother with the code tags if you are going to enable the Disable BBCode in this post option.