Skip to Content
avatar image
Former Member

How to export a single table to ATL file using command line on an SQL server?

Hi Community,

I have tried the following the following command and get the error
Unrecognized option:-Xp@t@D:\CONNECT_DEV\CONFIGS\DEV3\ATL\export.atl@ODS_DS.GM.Z_CS_QUOTE_POLICY_BASE

This is the command I tried running
"C:\Program Files (x86)\SAP BusinessObjects\Data Services\bin\AL_ENGINE.exe" -QETL_DS_C_REPO -NMicrosoft_SQL_Server -passphrasedesigner -g -U -P -SGW-SQL-DV01 -Xp@t@D:\CONNECT_DEV\CONFIGS\DEV3\ATL\export.atl@ODS_DS.GM.Z_CS_QUOTE_POLICY_BASE

Thanks for your help.
Diane Smith

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 06 at 01:42 PM

    Your export option format is correct indeed.

    But the <ObjectType> can only be one of the following:
    P : Exports all Projects
    J : Exports all Jobs
    W : Exports all Work flows
    D : Exports all Dataflows
    T : Exports all Idocs
    F : Exports all user defined File formats
    X : Exports all XML and DTD Message formats
    S : Exports all Datastores
    C : Exports all Custom functions
    B : Exports all COBOL Copybooks
    E : Exports all Excel workbooks
    p : Exports all System Profiles
    v : Exports all Substitution Parameter Configurations
    K : Exports all SDK transform Configurations

    No lowercase t, no table.

    Add comment
    10|10000 characters needed characters exceeded