Datastage v752s01 Import error (importing from command line)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cconlon
Participant
Posts: 1
Joined: Mon Mar 05, 2007 6:02 pm
Location: Sydney

Datastage v752s01 Import error (importing from command line)

Post by cconlon »

I'm having trouble using the 'dscmdimport.ext' command. When I run it from the command line, specifying as below (where TEST is the project and 'D:\Apps\DataStage_Client\ribs_xfm_sos_service_load.dsx' is the filepath):

dscmdimport /H <host> /U <username> /P <password> TEST D:\Apps\DataStage_Client\ribs_xfm_sos_service_load.dsx /V

I get this message:

Attaching to '<host>' ...
dscmdimport aborted:
Failed to attach to the project

Any suggestions as to why it didn't work? The empty project TEST was just created, without protections.
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If my memory serves, the mandatory argument (the DSX name) should be last on the command line. Try moving the /V switch to a position earlier in the command.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Code: Select all

SET DSImportCmd=C:\Progra~1\Ascential\DataStage7.5.1\dsimport.exe


Code: Select all

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

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

  echo %DSImportCmd% /H=%Host% /U=%User% /P=%Password% %Project% %ProjectDir%\%%i >> %LogFileName%
  %DSImportCmd% /H=%Host% /U=%User% /P=%Password% %Project% %ProjectDir%\%%i >> %LogFileName%
  IF NOT %ERRORLEVEL%==0 GOTO ProjFail

  ECHO. >> %LogFileName%
  ECHO *** Completed Import for Project: %Project% on Host: %Host% >> %LogFileName%
  ECHO     from File: %ProjectDir%\%%i >> %LogFileName%
  ECHO. >> %LogFileName%
)
Mamu Kim
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

You need to give '=' after the parameters like /H /U /P.

Code: Select all

dscmdimport /H=host /U=username /P=password TEST D:\Apps\DataStage_Client\ribs_xfm_sos_service_load.dsx /V
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply