Help on dsexport

[kumar_s]

Leave me and my logo alone.

This forced to ask me once more.

[kumar_s]

Can we export multiple jobs to same "dsx" file from command line using dsexport

Can somebody help in syntax?

Thanks kura, for getting us back to track.
dscmdexport can be used to export the whole project into single dsx.
dsexport can be used to export individual file into individual dsx.
If reuqired, you can merge all those individual files into single file.

[kduke]

Aim to please.

Code: Select all

    for /F "tokens=1" %%i in (%JobList%) do (

        ECHO Exporting %%i to Project: %Project% on Host: %Host%

        echo "%DSExportCmd% /H=%Host% /U=%User% /P=%Password% /JOB=%%i %Project% %%i.dsx" >> %LogFileName%
        %DSExportCmd% /H=%Host% /U=%User% /P=%Password% /JOB=%%i %Project% %%i.dsx >> %LogFileName%
        IF NOT %ERRORLEVEL%==0 GOTO ProjFail

        ECHO. >> %LogFileName%
        ECHO *** Completed Export for Project: %Project% on Host: %Host% >> %LogFileName%
        ECHO     from File: %ProjectDir%\%%i >> %LogFileName%
        ECHO. >> %LogFileName%
    )

Straight from the backup script.

[kduke]

Might need this line.

Code: Select all

SET DSExportCmd=C:\Progra~1\Ascential\DataStage7.5.1\DsExport.exe

[kduke]

Here is the second one.

Code: Select all

    SET DSExportCmd=C:\Progra~1\Ascential\DataStage7.5.1\dscmdexport.exe

Code: Select all

%DSExportCmd% /H=%Host% /U=%User% /P=%Password% %%i %BackupDir%%DsxDate%\%Host%_%%i.dsx

This does a whole project backup.

[kumar_s]

%DSExportCmd% /H=%Host% /U=%User% /P=%Password% /JOB=%%i %Project% %%i.dsx >> %LogFileName%

Kim, This will again export Job wise into the specified directory isn't?
You changed the color of the logo again, Cant resist.

[kduke]

That is correct. You need to put a full path on the dsx to put it somewhere other than the current directory.

One day only on the less colorful logo. Okay?

[kumar_s]

One day only on the less colorful logo. Okay?

I ll wait for your next change.

[OddJob]

I've found that dsexport also supports:

/XML
/EXT

and

/EXEC
/APPEND

I think /EXEC exports the executable part - the dsx produced only has a DSEXECJOB section.
/APPEND can only be used with /EXEC and appends onto an existing dsx file.

I found this by opening the file dsexport.exe in a hex editor and looking at the clear text in the file. The complete list of apparent switches is:
/JOB=
/XML
/EXT
/EXEC
/APPEND
/ASK
/ALL
/NUA

[ray.wurlod]

You could have used strings utility for that!

[OddJob]

That's exactly (and I mean verbatim) what somebody else said to me in the office.

However, I'm from a Windows background and prefer trawling through hex files in UltraEdit :D