Export several jobs to one file using command line

[clarcombe]

I would like to use dsexport to export several jobs to one file e.g.

c:\Progra~1\Ascential\DataStage7.5.2\dsexport.exe /H=***** /U=***** /P=***** COP_DEV /job=BI1_000_FMI005 Z:\partages\ERP_COPERNIC\SNCF_Datatage\Livraison\BI1\20080108\COP_BI1.dsx

c:\Progra~1\Ascential\DataStage7.5.2\dsexport.exe /H=****** /U=***** /P=***** COP_DEV /job=BI1_000_FNM010 Z:\partages\ERP_COPERNIC\SNCF_Datatage\Livraison\BI1\20080108\COP_BI1.dsx

The /append option is only allowed for exporting executables.

Question
Is there any way to do this either in a standard way or a workaround

[DS_SUPPORT]

There is a way, to append all the jobs to a single dsx. Do it as like what you are doing now, and after each execution append the dsx to a different file.

you need to do Some thing like

Code: Select all

::****************Begin Export Loop


For /F "tokens=1" %%i in (C:\export\DsxList.txt) do (

  echo **** Exporting Job %%i


C:\Progra~1\Ascential\DataStage7.5\dsexport /H=***** /U=***** /P=***** /JOB=%%i PROJ_TRAINING  c:\export\aa.dsx

  type C:\export\aa.dsx >> C:\export\dsfinal.dsx 

)


    ECHO *** Export completed successfully for projects:

If the type command is firing before the complete export of a particular job, then you might have to investigate PSLIST, or Search for PSLIST in the forum, i hope once Arndw , posted something related to PSLIST.

[clarcombe]

Interesting idea.

I had thought of doing a move *.dsx final.dsx but I like the idea of the type better as it means I have less excel code to modify

[kduke]

Each dsx file has a header. This would work if you stripped the header off. Not sure if it can ignore multiple headers in one file. Try it. Let us know.

[clarcombe]

I have left the headers in the dsx and it works fine.

[clarcombe]

In fact, I cannot export executables with each dsx and then concatenate them. I can only export the source code