Home Dashboard Directory Help
Search

Error while moving data from Hive table in HDInsight into Windows Azure SQL DB using SSIS by vishal0soni


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 783868
Opened: 4/16/2013 10:21:48 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

We were trying to transfer data from HDInsight to SQL DB using SSIS, but were not able to do so.

We were trying to follow the steps as suggested on one article here: http://alexeikh.wordpress.com/2012/05/03/moving-data-from-hive-table-in-ms-hadoop-into-sql-server-using-ssis-server/

We are getting an error “error [hy000] query returned non-zero code: failed Parse error line1:14 cannot recognize input near” in the SSIS ADO.NET source editor. Also it is showing a RED CROSS in both the source and destination field.

The screenshots and a video are posted on the link: http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5ed1f7ee-740b-49b7-a196-014e75a6b8ee    
(link to video is available in the comments)
Details
Sign in to post a comment.
Posted by Microsoft on 5/23/2013 at 1:24 PM
Hello Vishal. We’ve looked into this item. While it will not be addressed in the current release cycle, we have added it to a list for consideration for the next. Thank you for the feedback. We will keep track of the suggestion. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
SSIS Error.avi 4/16/2013 3.9 MB
270990.png 4/16/2013 7 KB