How to execute sqoop.cmd from SSIS package using Execute Process Task

to create new topics or reply. | New User Registration

This topic contains 3 replies, has 3 voices, and was last updated by  Mahesh Balakrishnan 1 year, 1 month ago.

  • Creator
    Topic
  • #45666

    Durga Prasad
    Participant

    Hi
    I am trying to execute sqoop.cmd from SSIS package using Execute Process Task

    Execute Process Task in SSIS Package
    Executable: C:\Hadoop\sqoop-1.4.2\bin\sqoop.cmd
    Arguments: /C “sqoop import -connect “jdbc:sqlserver://machinename:1433;database=test;username=myuser;password=mypwd;” -table emp -target-dir /user/emptable -m 1″

    Please help me how to solve this.
    thanks
    Durga

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘How to execute sqoop.cmd from SSIS package using Execute Process Task’ is closed to new replies.

  • Author
    Replies
  • #49596

    Hi Durga,

    There is a Microsoft document which talks about how to leverage a hadoop cluster using SQLServer Integration services (SSIS): http://msdn.microsoft.com/en-us/library/jj720569.aspx

    Hope this can help you out.

    -Mahesh

    Collapse
    #46490

    Durga Prasad
    Participant

    Hi Koelli,

    Its not working, I believe that its not possible with this version.

    Thanks
    Durga

    Collapse
    #46472

    Koelli Mungee
    Moderator

    Hi Durga,

    Were you able to get this working? Were you able to do something simple like sqoop version?

    thanks,
    Koelli

    Collapse
Viewing 3 replies - 1 through 3 (of 3 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.