Page 1 of 1
DSExport to export selective jobs
Posted: Wed Oct 21, 2009 5:13 am
by sridharvis
Hi,
This is the first time i am trying to execute the dsexport command. I was figuring out, is thery any way i could export only 4 jobs/sequencers under the same dsx name ?
I used the below command as mentioned in Manager Guide
dsexport.exe /H hostname /U username /P password /O omitflag project
pathname1
Posted: Wed Oct 21, 2009 5:31 am
by ArndW
I don't think that the command-line option has an "append" switch so it might be better to just create 4 files and then "cat" them together.
Posted: Wed Oct 21, 2009 8:16 am
by priyadarshikunal
DSExport in 8.0 gives an option to append to an existing file. Don't remember much about 7.x at the moment. If its not available serarh for perl scripts to concatanate/split the DSX to get what you want.
Posted: Wed Oct 21, 2009 10:28 am
by ArndW
What is the option at version 8, priyadarshikunal, if you post that the original poster might try to see if it works at 7
Posted: Thu Oct 22, 2009 4:10 am
by DS_SUPPORT
generally for this requirement, i will write a bat file, which will export each job in a different dsx file and finnally append all the dsx files to one.
Code: Select all
For /F "tokens=1" %%i in (C:\export\DsxList.txt) do (
C:\Progra~1\Ascential\DataStage7.5\dsexport /H=AnandLocal /U=Administrator /P=****** /JOB=%%i PRJ_TRAINING c:\export\aa.dsx
type C:\export\aa.dsx >> C:\export\dsfinal.dsx
)
Here "C:\export\DsxList.txt" will contain all the jobnames which has to be exported, and each job will be exported to aa.dsx individually and finally it will be appended to dsfinal.dsx.