DSXchange

LOL

First you said current timestamp with microseconds and now current timestamp in microseconds... which one is it?

Didn't know that was there... bookmarked now for future promotion.

Your connection user most likely won't have permissions to do this, or really shouldn't. Have procs created to drop/rebuild them and then get permission to execute the procs, do so before- and after-sql.

It's not "dir /-o" but "dir /o:" followed by the sortfield. So use " dir /b /o:-n <pattern> " for a Bare listing in reverse Name order. And what makes you think you can't do a dir in an ftp session? :wink: One ftp call could get the 'latest' filename and then you could ...

If "direct the file to another location" means move it, that's just more O/S commands - i.e. move in DOS. A batch file can do all the work or you could execute the commands individually in a Sequence job, I suppose.

First step is to import the metadata from the existing service so you can load all that into the stage.

Well... there really isn't anywhere to change them, unless you're talking about editing the "D_" dictionary file? Ah... I guess you mean in the imported table metadata.

samsuf2002 wrote:We also have asp.net webservices by which we can do the same.

Meaning what? There is a webservice call available to bring it down? If yes, then I don't see why you couldn't do that in a job. Have you tried to yet?

Probably just forgot to untick it.

One 'trick' is to sort in reverse order and take the first one. For Windows, check out the /o option of dir to order the output, a "-" with it reverses the order.

Start / Run... / cmd and then dir /? to see the DOS help.

Anyone else there worked with XML? It's pretty daunting at frist to tackle it on your own. There are various validators out there, something Google should turn up. On the UNIX side I've used 'svalidate' from Java Beans and 'Echo10' most recently as it caught problems that the former did not. Both re...

How exactly are you "converting into varchar"?

What's the process to bring the website "down"? Do you have access to any kind of Enterprise Scheduler?

"Reset DataStage services"? Do you mean stop and restart the services on a scheduled basis? If so, why do you feel the need to do that?