Is it possible to automate the DataStage export of an entire

tbtcust · Post by **tbtcust** » Wed Jun 11, 2008 4:22 pm

Hello all. Is it possible to automate the export of an entire project via a batch job. I would like to run the export of an entire project via a schedule batch process.

Thanks in advance for any help.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 11, 2008 4:53 pm

Yes it is. Search DSXchange for dscmdexport command, possibly in combination with "BAT".

DS_SUPPORT · Post by **DS_SUPPORT** » Wed Jun 11, 2008 10:33 pm

Check in Kim Dukes website, he is having a batch utility to export all the projects in a server.

tbtcust · Post by **tbtcust** » Thu Jun 12, 2008 6:39 am

Thank you both. This is very good info and should work for me.

mandyli · Post by **mandyli** » Tue Sep 22, 2009 12:08 am

Hi

In IIS VERSION 8.01 dscmdexport is not working.

Any other option is there for exporting datastage project.

lstsaur · Post by **lstsaur** » Tue Sep 22, 2009 12:26 am

I have no problem to use the dscmdexport (version 8.0.1); it works just fine. What's the error message?

J.Calvo · Post by **J.Calvo** » Tue Oct 13, 2009 5:45 am

Our version is 8.0.1
I'm trying to do it now, with dscmdexport command and dsexport command, and with both i have the same problem, when the export has finished i can't found some items in it, READ ONLY ITEMS has not been included.
I don't know what is the solution.

nirav_2004 · Post by **nirav_2004** » Tue Oct 13, 2009 7:18 am

We have same version running on windows, and we are running auto export job everynight on all our environments. Its running without any issues. Please try to use following command...If you have any problem let me know...

Code: Select all

istool.exe export -dom %Domain% -u %User% -p %Password% -ar %ProjectDir%/%Project%.isx -ds ' -incdep -incexec "%Domain%/%Project%/*/*.*"' >> %ProjLogFileName%

chulett · Post by **chulett** » Tue Oct 13, 2009 7:27 am

That istool is only available in 8.1.1 with that 'comprehensive' patch installed.

J.Calvo · Post by **J.Calvo** » Tue Oct 13, 2009 9:29 am

Exactly, in our version we haven't this tool.

platonfi · Post by **platonfi** » Mon Nov 02, 2009 2:50 am

I wonder why I can not get the command functioning. I do have a lot of content in my project, but the export does nothing. It does not even create an empty target file, please see output below.

BTW, what is file extension .isx used here? Is the format supposed to be somehow different from regular .dsx?

Code: Select all

C:\dsbackup>C:\IBM\InformationServer_v8.1\Clients\istools\cli\istool.exe export
-dom etlmc-t1:9080 -u myusername -p mypassword -ar 001_VVDW_T.isx -ds '"ETLMC-T1.POSTI.FI/001_VVDW_T/*/*.*"'
Beginning Export
Elapsed time: 00:00:06
Exported 0 assets
C:\dsbackup>

platonfi · Post by **platonfi** » Mon Nov 02, 2009 3:31 am

I am answering my own question. There seems to be a bug as reported here: viewtopic.php?t=128327&highlight=istools

chulett · Post by **chulett** » Mon Nov 02, 2009 7:37 am

A known bug with an available patch, yes, as noted in that same thread.

DSXchange

Is it possible to automate the DataStage export of an entire

Is it possible to automate the DataStage export of an entire

I have problems too

Re: I have problems too

Re: Is it possible to automate the DataStage export of an en