Page 1 of 1
Creating individual .DSX files for my 800+ jobs
Posted: Wed May 27, 2009 9:14 am
by laiko
We would like to check in all our DS jobs to CVS. How can I create individual DSX files for all the jobs? -- well, apart from doing it one-by-one in Manager
Thanks in advance..
Posted: Wed May 27, 2009 9:17 am
by nagarjuna
Posted: Wed May 27, 2009 9:33 am
by chulett
That or one-by-one in a scripted loop.
DSX Cutter not working for me..
Posted: Thu May 28, 2009 2:04 pm
by laiko
I tried to use this script to create individual .DSX files for each job inside the category which I exported. When I did the export, I
only checked 'Job Designs' as Component and 'By Category' as Option. When I ran the 'perl DSX_Cutter.pl filename' where filename is my category .dsx file, it created the individual .dsx files, but filenames end in '?.dsx'. I renamed the files by removing the '?' . When I tried to import the files, I get an error 'No Objects found for import' - and nothing gets imported.
What did I do wrong????
Posted: Thu May 28, 2009 2:18 pm
by chulett
Hard to say... what's actually *in* the .dsx files the cutter created?
Posted: Thu May 28, 2009 9:59 pm
by laiko
It has the header (which is also in the category .dsx) + its own individual scripts. Something like:
Code: Select all
BEGIN HEADER
CharacterSet "CP1252"
ExportingTool "Ascential DataStage Export"
ToolVersion "4"
ServerName "My_Server"
ToolInstanceID "My_Project"
MDISVersion "1.0"
Date "2009-05-28"
Time "10.43.29"
ServerVersion "7.5.1.A"
END HEADER
BEGIN DSJOB
Identifier "My_Job"
...
END DSJOB
Posted: Thu May 28, 2009 10:15 pm
by chulett
So I assume the ". . ." is where you hacked out all of the job itself, yes? As a test, export this single job manually from the GUI and compare the two output files. That should help give us a clue as to what may be missing.