1

Recently had a client who needed me to connect his online store databases to a POS system using MS Sql Azure 2014.

However, the normal methods using BULK insert nor SQl Service broker do not work. I usually receive errors like "Not available in this version of SQL server.

I tried the online azure website but I'm on windows 10 which does not seem to work well with silverlight....and using visual studio to access the database, does not accept bulk insert commands either....

Any guides on how to use to utilize these... wityh azure...normal SQL server 2014 ways do not work.

  • SSIS can connect to Azure SQL. You will have to run the SSIS package from a different server though. Not sure on licensing ramifications. If it's a simple CSV then you could use Powershell to loop through the CSV and insert the data. What are the performance requirements? – Jonathan Fite Nov 2 '15 at 20:15
  • I just want the ability....nothing fancy....I'll try the powershell route – deek Nov 3 '15 at 3:29
1

Use the BCP utility to import and Export. as the following states, Azure doesn't seem to support the Bulk insert... see here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.