DSXchange

Sure, you just need to get your hands on a UNIX Excel ODBC driver. Microsoft has a free one for Linux if that is your O/S.

Let us know what you find out. To be honest, I'm not really following your solution but perhaps it's not important that I do if you've got something that works for you now.

I'd start with your SysAdmin for that server, make sure you don't simply have an issue with sendmail in general from that box. If you can use that sendmail command outside of DataStage but it fails inside it, that would help narrow things down.

Thanks for the link back, forgot that bit.

Typically that would be because your batch file has stopped to ask a question and is waiting for an answer. Could be a simple yes/no or could be something like a prompt for a password. And this probably because the scheduled job runs under a different userid.

Sharali001 wrote:If there is any othet alternate option then please share your Ideas with me.

Upgrade.

Both. Either. Depends on the platform.

I'm not aware of any mechanism specifically for this. Of course, worst case you could type the metadata in manually. There's another discussion of your topic here which outlines a mechanism where you could become familiar with what that DDL would look like in a .dsx export and then create something ...

So, which is it - are you targeting a flat file or a database table? If a table, what is the data type of the target field? Also note that Ray said "such as" so you would look for an equivalent in SQL Server.

does the folder stage really read all file content first, even I only use one column for filename? From what I recall and what you've documented - yes. If literally all you need are the filenames, I'd suggest an ExecSH command Before Job to list the filenames to a flat file and then use that file a...

Agreed. Especially considering you not being aware of what XMETA is used for.

:!: Please don't pull stunts like this. You posted a question on outputting XML to multiple files and then (apparently) didn't like the fact that you couldn't read all of Ernie's answer. So you then deleted your reply then edited your original question to be something completely different. :evil: Ne...

I would suggest dumping the SQL.GUID element and just loading it to a plain old Varchar(36).

First off, there are no "junk" characters... but I'll save that lecture for others. We'd probably need to see your complete derivation to be able to help, something without the "etc" in it. And I'm also curious if you are doing any other derivations on the strings post-convert or...

EReplace was added to the Parallel world in the 9.1 release, I do believe. So you could use a Server job (is it doing anything that requires PX?) or perhaps use a BASIC Transformer. Or you could find the C++ version called pxEReplace that users put together and posted here, give that one a shot alth...