command line functins that import and export the DS jobs

[rumu]

Hi All,
What is the command line functins that import and export the DS jobs?

[dsusr]

Hi,

You can find the utilities for command line export and import from DataStage Manager guide.

There are two utilities called dsimport.exe and dsexport.exe by which you can take the import and export from command line.

Regards
dsusr

[WoMaWil]

dsexport does only export a whole project. dsimport does import, what's in the file.

If you want to export individual elements (single jobs, single routines and single transforms) you can use for example a third-party-Tool called dsmove.

Wolfgang

[rumu]

dsexport does only export a whole project. dsimport does import, what's in the file.

If you want to export individual elements (single jobs, single routines and single transforms) you can use for example a third-party-Tool called dsmove.

Wolfgang

Thnx for your promt response.

[kaps]

Hi

You can export individial jobs from command line. I don't know why others are saying it's not possinle. I have heard the samething but I could export an individual job from command line using dsexport command.

Thanks

[ray.wurlod]

But you can't do it with the client-based dscmdexport command. If you disagree with that assertion, please supply the method.

[mdan]

to export an individual job use
dsexport [/XML] /U=username /P=password /H=hostname /JOB=jobname projectname to_file_name

Hi

You can export individial jobs from command line. I don't know why others are saying it's not possinle. I have heard the samething but I could export an individual job from command line using dsexport command.

Thanks

[ray.wurlod]

Now show us with dscmdexport command. This is the command about which it is asserted that individual jobs can not be exported, not dsexport.

[PhilHibbs]

Now show us with dscmdexport command. This is the command about which it is asserted that individual jobs can not be exported, not dsexport.

I think it's hardly fair to criticize someone for posting a useful answer to the original poster's question.

[kaps]

Ray

I don't dare to disagree with you. But can you please explain why do you want to use dscmdexport when we can accomplish the same objective using dsexport ?

by the way dsexport command can be run without any user interaction.

Thanks

[Neil C]

Is there a parameter to enable this to append to to_file_name file?

[WoMaWil]

Neil,

for to control dsexport, you will programm just somewhere something, for example a dos-batchfile.

There you can use normal pipes.

type file1 >> file2

(append file1 to file2)

Wolfgang

[PhilHibbs]

Neil,
for to control dsexport, you will programm just somewhere something, for example a dos-batchfile.
There you can use normal pipes.
type file1 >> file2
(append file1 to file2)
Wolfgang

The problem with this is that when your batch executes dsexport, the dsexport starts running as a separate Windows process and your batch continues to execute in parallel. You will have to do something clever to detect when dsexport has finished executing. It may be possible to write a program that repeatedly tries to open the output file exclusively, which should fail while the dsexport command is running. I will investigate and update this post if I find an easy solution.

Update: Got it! You need to download pslist.exe from sysinternals.com, and use a batch file like this:

Code: Select all

@echo off
del %1.dsx
"C:\Program Files\Ascential\DataStage\dsexport" /U=dsadm /P=ascential /H=corus /JOB=%1 CorusITB_Dev %1.dsx

REM wait for file to exist
:1
if not exist %1.dsx goto 1

REM wait for the dsexport to finish
:2
pslist dsexport > nul
if not errorlevel 1 goto 2

REM file should exist now!
dir %1.dsx

Save that as export.bat along with the pslist.exe somewhere in your PATH (I recommend making a directory like c:\utils and add that to your path in the system properties), and run "export XXXX" where XXXX is your job name, and it will create a file XXXX.dsx that you can then concatenate to another .dsx file.

It will all go horribly wrong if the job doesn't exist, or the password is wrong, or you can't connect to the server for some reason, it will wait forever for the file to appear, but you can break out of it with [Ctrl]-C.

Update: If the export fails for any of the aforementioned reasons, you will get dialog boxes telling you about the problem. When you have got rid of these dialog boxes, it will create a file, so the batch will then terminate correctly without Ctrl-C.

[mickboland]

Is there any way to export the full project to XML?

[mickboland]

Is there any way to export the full project to XML from the cmd line?