Skip to Content
0

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

Apr 06 at 11:57 AM

28

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Apr 06 at 01:42 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded