Using Flexible Folders

This feature can help you if you cannot use fixed-name folders in SCM under a <sql_code> root. 

...

...

Normally DDL changes are placed in folders that use the CONVERT packaging method. However, when you need to package complex and interdependent changes, place them in a folder that uses the DDL_DIRECT or DIRECT packaging method instead. 

If the order that the multiple statements are listed in the single script is critical to the success of the script, then use the DDL_DIRECT or DIRECT packaging method. The DDL_DIRECT or DIRECT packaging method will preserve the order of the statements in the script. (The CONVERT packaging method may not preserve the order because it creates the change sets by doing a diff of before and after snapshots, and that comparison process does not know the original order of the statements.)

...

...

• Folders containing metadata.properties file are processed.
• Folders not containing metadata.properties file are skipped.

...

Available properties for metadata.properties

A full list of the properties that can be defined in metadata.properties filesis found here: Using the metadata.properties file

Some of the most commonly used properties are mentioned below:

ignore

Set to true or false. If true, packager skips this folder and all subfolders during processing. 

packageMethod

If specified, determines the processing method to use during packaging. The file is further parsed to determine the SQLFileType, which determines the order of processing. 

...

• CONVERT (convert)
• STOREDLOGIC (native)
• DIRECT (native)
• DDL_DIRECT (native)
• DATA_DML (native)
• SQLFILE (native)
• SSIS (native)

rerunnable

Important: The newer rerunnable property replaces two properties in metadata.properties.  These older properties that are are deprecated and should not no longer be used :(allowRepackaging

...

and archive).

Set rerunnable to true or false.:

• true - the SQL code file is not archived. It can be repackaged. 
• false - the SQL code file is archived. It cannot be repackaged. 

If not set, packager checks whether fixed-name folders are being used under the <sql_code> root and assigns the default rerunnable property value as follows. In general, stored logic is rerunnable. 

versionStrategy

When you are using the rerunnable=true property, you can have multiple versions of the change set for different iterations of the sql script.  Stored Logic is usually configured to use rerunnable=true.  You can then use the versionStrategy property to indicate whether to deploy all versions of the rerunnable change set, or only deploy the latest version of the rerunnable change set.

Set versionStrategy to deployAll or deployLatest:

• deployAll - deploy all eligible versions in the order they appear in changelog.xml. This is the default.
• deployLatest - deploy only the latest eligible version.

See also these pages for an overview of packager workflows, guidelines for writing scripts, and when to use which folder or packaging method:

...

SQL Server Database Objects and Packaging

Fixed Folder Names

Using the metadata.properties file

How To: Choose Between CONVERT (ddl) and DDL_DIRECT (ddl_direct) Packaging Methods

...