Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Sql data tools 2010

I am running sql server 2012

I am trying to create a simple dataflow task in sql server data tools 2010

it is trying to access a view which is retrieving data from a  sql server that is on Microsoft azure.  (I can run the view in ssms just fine.....very simple query)


It keeps locking up with the dreaded
microsoft visual studio is waiting for an internal operation to complete

no problems with any other views trying to access data from tables not on azure

any ideas???
0
johnnyg123
Asked:
johnnyg123
  • 2
1 Solution
 
Jacques Bourgeois (James Burger)PresidentCommented:
If you are working with SQL Server 2012, why are you using the 2010 version of the data tools?
0
 
johnnyg123Author Commented:
Good question....that's what got installed with the 2012 install

I did figure out a solution which makes no sense but.....

Instead of using the view directly in the data access mode, I changed it to sql command and did a select * from the view....not sure why that made a difference but it did
0
 
johnnyg123Author Commented:
Found solution on my own
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now