?
Solved

Sql data tools 2010

Posted on 2014-04-03
3
Medium Priority
?
237 Views
Last Modified: 2014-11-12
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
Comment
Question by:johnnyg123
  • 2
3 Comments
 
LVL 40
ID: 39975930
If you are working with SQL Server 2012, why are you using the 2010 version of the data tools?
0
 

Accepted Solution

by:
johnnyg123 earned 0 total points
ID: 40018395
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
 

Author Closing Comment

by:johnnyg123
ID: 40026814
Found solution on my own
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question