DSXchange

Other options, like Transformer Looping, are not available in a Server job. That's why I wanted to double-check.

I ask them to post here... and contact the Membership Director as well.

When you have an issue like this you start a new post rather then reply to anything similar you can find. I've taken the liberty of splitting your post out on its own and deleting the others so we can have a conversation in one place... here.

Do an exact search for "When checking operator: Dropping component" here and see if any of the 47 other posts help.

I bought the premium membership. Still I am not able to see this post. Your ID (which is shown in the left-hand side box on every post) doesn't show any evidence of your 'Premium-ness' yet. AFAIK, it's still a manual process and can take a few days. If you still have an issue with your membership, ...

Hmmm... I believe you could always specify the key in the schema file, Ray mentions the syntax in (for example) this post. The link you posted seems to indicate a different issue? Specifically, Arnd noted that the key information was not 'passed onwards'. Perhaps I read too much into what the actual...

Not sure that where it is coming from matters, however not being a fixed number can unless you are aware of the maximum number it could be. Then you can perform a horizontal Pivot and filter out the 'empty' occurrences afterwards. There are some alternatives but first curious if you are actually usi...

... unless you specify the key(s) in your schema file.

aschindler wrote:Specify at least one key column in the input schema.

The answer is right there in the error message you posted.

Again... questions not answered and the same information repeated. Not sure how you can think that is helpful. :? A stored procedure is a 'transform' if there are input and output links to it, i.e. it transforms rows passing through it. In your design it should be set to 'Source'... or in the sugges...

Without a specific plan and while understanding what each option controls, you could always try starting back at 1 and then raising the value in much smaller increments rather then going 'all in' right away. Increment it until the job aborts and then back it back down slightly.

You didn't answer Ray's question, you basically just repeated the same information from your initial post. To me your design is... backwards. You source from a stored procedure when that proc delivers rows into the job. You target one when it does the kind of work that you are doing, using a single ...

Can I know what is being suggested in the above premium content. I've opened it up as there wasn't much left you couldn't see. As Arnd noted, it is always best to start your own post when you come here with a problem, no matter how 'same' the issue seems to be to others you find here. If you can't ...

Not sure if there's a previous version involved but the default padding character is "0x0" and you'd need to change that to "0x20" (via the APT variable that Arnd noted) so that it pads with spaces.

Are you seeing that only for CHAR fields?