SSIS & Azure SQL Managed Instance with MFA
We've been testing out Azure SQL Managed Instance and created SSIS packages to run against it. We set connections using the ADO.Net connection manager and all worked well. We recently had to apply MFA to all logins and this is causing issues within SSIS as there is no MFA option for logins like there is in SSMS. We can connect if we use SQL Server Authentication but we'd rather not do that. When using Active Directory Integrated Authentication, all of our test connections fail and the package will not run locally. In SSMS, there is an integrated authentication with MFA option and that works from within SSMS. How can we use SSIS and connect to the database using Windows Authentication when MFA is required?
Azure SQL Web Portal .dacpac Functionality
I've had so far success in creating SQL Server databases using .bacpac through the Azure Portal web interface. That said, what I need is a way to update said databases' structures using a .dacpac through through the Azure Portal web interface as well. I understand this might be possible using SSMS, but I find the over the network interaction response time to be less than optimal. Is there such functionality available using the Azure Portal web interface (not to create a new database using a .bacpac file but to update its structure using a .dacpac file.) If not, will there be such a feature implementation in the near future?
DATE_FORMAT is not supported for EXTERNAL FILE FORMAT.
I have been trying to create an external table from a CSV data set that does not use the default date format that synapse understands. So according to the documentation (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-file-format-transact-sql?view=azure-sqldw-latest&tabs=delimited#examples) I should be able to specify a user defined format string as you can see in the picture below. But if I do so I get the following error "DATE_FORMAT is not supported for EXTERNAL FILE FORMAT." and I'm not sure what I'm missing in the documentation. I'm currently running in the Serverless SQL pool so could it be that this is just supported for dedicated pools? Thank you for your time and any help or insights would be greatly appreciated.
Deploying a Dacpac using SQLPackage
Hi, I'm trying to use SQLPackage to deploy a Dacpac using AccessToken authentication. I'm using the following command... .\sqlpackage.exe /Action:Publish /SourceFile:Database.dacpac /TargetServerName:xxxx.database.windows.net /TargetDatabaseName:DatabaseName /AccessToken:xxxx The error message I'm getting is: Unable to connect to target server 'xxxx.database.windows.net'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server. Login failed for user '<token-identified principal>'. Any ideas what's wrong here?
