Resolve DACPAC Export Exception: FillFactor is Not Supported

Another interesting data-tier application export exception: FillFactor is not supported when used as part of a data package.

Use the following query to identify the problem indexes:

SELECT              OBJECT_NAME(i.object_id) AS TableName,
                    c.[name] AS ColumnName,
                    i.[name] AS IndexName,
                    i.fill_factor AS [FillFactor]
FROM                sys.indexes i
INNER JOIN          sys.index_columns ic ON ic.object_id = i.object_id AND ic.index_id = i.index_id
INNER JOIN          sys.columns c ON c.object_id = ic.object_id AND c.column_id = ic.index_column_id
WHERE               i.Fill_factor != 0




Then, one-by-one, bring up the designer for each table that has an offending index. Right-click the designer and bring up the Indexes/Keys... dialog. Find the offending index, then change its Fill Specification -> Fill Factor property to 0. Close the dialog and save the table.