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

[Former Member]

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

[former_member187605]

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.