Solved

Sql data tools 2010

Posted on 2014-04-03
3
216 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL view 2 27
SSRS Enable Remote Errors 4 26
Using server 2012 R2 KMS host to activate Server 2016 clients 5 36
SQL - Update field defined as Text 6 17
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

773 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