Solved

Sql data tools 2010

Posted on 2014-04-03
3
221 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

752 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