SSMS Error with PolyBase to SQL Server: "Set Property FileFormatName"
When attempting to script out a create statement for an external table defined on a SQL Server source in SSMS 18 Preview 7, I receive the following error:
TITLE: Microsoft SQL Server Management Studio
To accomplish this action, set property FileFormatName. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18092.0+((SSMS_Rel).190228-0027)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyNotSetExceptionText&LinkId=20476
I am able to script external tables built on Hadoop or Azure Blob Storage external data sources. I can also script drop or select statements against the SQL-backed external table.
Could you upgrade to SSMS 18.2 and let me know if this is still an issue? 18.2 has quite a few fixes for “external” objects… so I hope this is not a problem anymore for you.
If it is, how did you create such table?
Kevin Feasel commented
18.2 has fixed this issue. I am now able to script external table creation against newer PolyBase external data sources like SQL, Mongo/Cosmos, and ODBC.