DSXchange

Technically that "?" should work as it is a wild-card match for any single character which you have in your 1,2,3 differentiator. It works fine from DOS but perhaps the stage doesn't allow or 'understand' it. As noted, you can fall back on the 'splat' or asterisk to mean 'any number of ch...

OK... details? Or are we just supposed to guess what you might be doing in your job?

I doubt the pool of people using this here is anything other than minuscule. Best to contact your official support provider for this, I would think.

The answer will also depend on what kind of 'load' you are referring to.

Sorry, but does the Teradata Connector stage use ODBC under the covers?

Nope, sorry, can't... don't have that particular skill set.

Hadn't seen this one yet.

priyadarshikunal wrote:Seems like you are using a list loop with seretator as , and values 1,1,1

No, they were noted as being the Start, Stop and Step values used in the stage... as in looping "from 1 to 1 by 1", a single iteration - which would mean there's absolutely no need for the loop. Hence the confusion.

It's not as far as I know. There is a Java PACK that will allow you to do things like this but it is a option you need to purchase. Perhaps with a build-op?

:!: I for one would never suggest anyone monkey with their DSParam files in this manner or try replacing it with a job specific list. There's no need for any kind of 'trick' like this, never mind the fact that it can be... dangerous. As noted, getting values from a flat file can be as simple as a 'c...

I don't know about anyone else, but now I'm confused as to what it is you are trying to do. :? The assumption up to this point was that you needed to run your job five times in a row using different parameter values. Is that not the case? Are you saying it may need to run up to five times in a singl...

What we're being told is that all stages should be installed automatically. One 'solution' might be to uninstall and reinstall everything but without knowing what happened the first time there's nothing to guarentee it won't happen again. You could always try it... but I would suggest contacting you...

No clue, gots me no SQL Server.

It may be useful to do a binary ftp transfer. This will guarantee any value conversion. Not quite sure what you meant to say, but a 'binary' transfer means no conversion is done during the transfer. And all an ASCII transfer does is convert record delimiters, neither touches or converts anything in...

I am not a not a Premium member so not able to see the whole message. Sorry, but I really don't understand why people think we don't know that or think that we don't know how things work around here. :? We make a deliberate choice as to which posts to mark as Premium Content and you make a delibera...