SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console)

Reply
New Contributor r_d
New Contributor
Posts: 2

Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console)

[ Edited ]

Hello,

 

I have googled far and wide to no avail. I am using the Batch Export Tool (http://documentation.sas.com/?docsetId=bisag&docsetTarget=n008xsxs34mvcwn1qrgcmugpzu6i.htm&docsetVer...).

 

I can successfully use the tool no problem. But I am having an issue in getting 'Folder Objects'.

 

Using the export wizard in DI Studio or Management console, I can right click at the highest folder level and create an export package. If I then select a job, then it will be exported along with all the above folder objects.

 

Using the Batch Export Tool, I cannot find that I can do the same thing. I can select jobs and export them, but it doesn't include the above folder objects. I can select the folder the job is in, and just choose to export jobs (-types Job), but it exports every job in the folder (not what I need, some folders are massive). Lastly, I have tried to export the job, and then separately export the folder, but the option '-types Folder' is not valid.

 

In the end I am trying to achieve a package that can be imported, using the import tool, to a target folder, and within that target folder it keeps the same folder path down to the job (this can be achieved using the manual wizards).

 

Thanks in advance!

New Contributor r_d
New Contributor
Posts: 2

Re: Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console

As usual... I've answered this myself immediately after asking Smiley LOL

 

The solution is.... List the folder path first, e.g. -objects "/Top Folder/My Folder/Daily/" "/Top Folder/My Folder/Daily/Job_Name(Job)" -subprop -types Job

 

This seems to have the effect that, you select the 'Folder Object', you then say exactly which jobs in the folder you want. I'd tried it the wrong way round Smiley Indifferent

SAS Super FREQ
Posts: 724

Re: Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console

Please provide the commands you have tried. The ExportPackage has an option to specify a name pattern you may also explicitly specify the object your interested in.

 

Here is an example using the -name option

ExportPackage.exe -profile <yourProfile> -package "c:\temp\test.spk" -objects "/shared data/stp_samples"  -includeEmptyFolders -name display -nameMatchType STARTSWITH
Ask a Question
Discussion stats
  • 2 replies
  • 97 views
  • 1 like
  • 2 in conversation