SQL Server 2019 supports non-XML format files and XML format files for bulk exporting and importing. Find out about non-XML format files and their benefits. You can create a non-XML format file ...

Thanks for the info all.<BR><BR>For my current need, a trimmed format did the trick but I'll keep in mind datepart and datename.

For various historical reasons I'm sure, SQL Server/Azure SQL connections require the format <IPAddress/DNSName>, using a comma instead of a colon to separate the IP/name and port. ADS (and SSMS) dont ...