This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 6%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
I made an Azure SQL Database and I am trying to use an SSIS package in Visual Studio to move tables and views to it from my desktop SQL Server 2016 database. I get an error message about the "USE" statement. I don't know why my script would even have a "USE" statement since I am not switching between databases. I am just moving tables and views from a single database locally to a single database in Azure. How can I fix this? Am I just going about this the wrong way?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Andrew Harris , great to hear things worked for you. You can mark the answer as 'Accepted Answer' that helped you, so to help others having similar queries.
Alberto,
I was able to successfully migrate a database using the DMA. I had been selecting "assessment" instead of "migration". Once I switched to migration I was able to use SQL Server authentication and everything worked great. Thank you for all of your help.
-Andrew
Wonderful. I am really glad it worked for you!
DMA takes care of many things in the background. It disables foreign keys and non-clustered indexes ahead of migration and re-enable them after data migration is done. It reads the data in parallel from the tables and perform BULK INSERTs into the target tables. It also takes care of identity columns and this can be a real problem, as some migration methods can left the seed value set to 1. This tool takes care of many challenges you many not see at this time.
In addition, read here all the capabilities this tool has that probably you wont' have with SSIS or will require hours of your time to develop them in SSIS.
I upgraded to "Pay as you Go" and still get the same error message:
Failed to fetch subscription list from Azure.
AADSTS16000: Either multiple user identities are available for the current request or selected account is not supported for the scenario.
Are you sure I can't use SSIS to do this? I'm not trying to do a one-time migration. I need a way to regularly copy one or more tables/views from my local SQL Server 2016 to Azure SQL Database. This was very easy to do with SSIS when my cloud database was a SQL Server database. Now it seems to be very difficult. Am I missing something?
I upgraded to "Pay as you Go" and I still get the same error message.
Do you have many objects/work created with this subscription? It seems you were testing Azure. Can you create a pay as you go account associated with a email account and try with the newly created subscription?
It forces me to log in to an Azure account first. There is no opportunity to specify the SQL database.
Does it matter that I'm on a free account? Part of the error message says " or selected account is not supported for the scenario."
Oh yes! If you applied for the $200 credit you have option for Azure SQL DTU S0 only. Please refer to this page to know what options are available for you and their limits.