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

This topic contains 3 replies, has 3 voices, and was last updated by  Mahesh Balakrishnan 6 months, 2 weeks 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)