DSXchange

Start by looking at UpCase() so you don't have to worry about "Attn" versus "ATTN" (etc) and then Index() to determine if those substrings are present. Any answer other than zero = yes.

OK... just a couple of small points. There's absolutely no need for a second job. And I wouldn't consider anything I wrote up to be any kind of a 'workaround' but rather How It Is Done. FYI.

Found this which mentions those errors. And once any PATH issue has been resolved, you restart everything so they take effect.

nagsep9 wrote:also do we need to do any pre-check before starting the DS load?

That's a pretty wide open question. I'll just start with "no".

Interesting!

You still need to have some patience, I'm afraid...

Yes. From the documentation: URI Is a pathname connecting the Stage to a source file on a remote host. It has the Open dependent property. You can repeat this property to specify multiple URIs, or you can use a wildcard in the path to retrieve a number of files. You can specify an absolute or a rela...

I'm assuming it's part of the new XML stage but couldn't tell you where or exactly how it was implemented... but I'm sure it would be documented somewhere. In the Old World, you designate a Trigger Column and whenever the value in it changes the current file is closed and a new one opened. So we wou...

Spell out your requirements in words rather than simply post before and after pictures. This not only helps us but could very well help you as well.

There is a "trigger column" property that does exactly that.

So... this is intermittent? Meaning you use the identical command line several times and it sometimes works and it sometimes fails? Or now that you've started to get the 401 error you can no longer do imports or exports?

I don't know specifically what it means here but a "401" error is generally an authentication error, an "unauthorized" attempt to do something. Out of curiosity, does your user have the permissions it would need to do this?

Try it, let us know. It would basically be a 'create table' statement. Create and populate it yourself once so you can import and leverage the metadata. And in your shoes I would check with support, see what advice they have.

Start your own post. Explain your issue.

It wasn't the right section but this is... so here we are.

I've been told in the past that the best email to use is "editor@dsxchange.net", (note that it is .net and not .com) hope that still holds true.

Well... I have no actual experience with this as I've never worked on a Windows edition of DataStage but you should have Excel ODBC drivers you can leverage for this. At least for the reading part. No clue how well they write back to Excel or if writing back to the same file you are reading will be ...