DWLoader works in SSIS Execution Process Task?


  • Does anyone knows if PDW's DWLoader works in SSIS Execution Process Task? Is there a sample?

    I struggle to find documentation on using DWLoader.exe in Execution Process Task (EPT) of SSIS. There are articles in PDW BOL about DWLoader.exe or SSIS to load data, however, there is no article I can find about using DWLoader.exe in Execution Process Task SSIS. I'd expect SSIS to behave the same way as we execute it in Command Prompt.

    A working (dwloader.exe) command string when putting to run in [Execution Process Task] in SSIS failed and it is hard to trap the errors. Tried writing the error out in my command string, as well as setting the StandardErrorVariable of the task, neither one caught the details about the error. I also put the same command string in a bat file and then ran it, it worked. I then used EPT to run my bat, that actually succeeded. (That indicated to me Execution Process Task might have interpreted my string differently).

    • Edited by CT2000 Friday, September 27, 2013 1:21 AM
    Friday, September 27, 2013 12:05 AM

All replies

  • Yes DWLoader works in a SSIS 2012 Process Task.

    In the Process Task, right-click and select Edit.
    This will bring up the  Execute Process Task Editor window.
    Select the Process menu option on the left.

    Set the following Process attributes:

    • RequireFullFileName:  True
    • Executable: C:\Program Files\Microsoft SQL Server Parallel Data Warehouse\100\dwLoader.exe
    • Arguments: -i "C:\TestFiles\SAMPLE.CSV" -T TESTPDW.dbo.TestTable -R "C:\TestFiles\SAMPLE.reject" -rt value -rv 100 -t "|" -r \r\n -E -m -M FastAppend -fh 1  

    The settings above will attempt to load the CSV file into the TestTable table, and will quit if errors exceed 100.

    Thursday, November 21, 2013 6:23 PM
  • It solved my problem.....i was writing command same as Command prompt-

    PSCP -i D:\UAT\Res.ppk -pw Password21 D:\UAT\ Res@

    and when i used only -

     -i D:\UAT\Res.ppk -pw P@ssword21 D:\UAT\ Res@

    then it solved my purpose.

    Regards, Ganesh

    Thursday, December 12, 2013 12:57 PM
  • Hi there,

    I am trying to use the dwloader utility to load data into a PDW database. I have created a batch file with the following syntax:

    dwloader.exe  -M fastappend -m -i "D:\SS\DATA_LOAD.txt" -T BATCH_V0.dbo.ATC_LOAD_TBL -R "D:\SS\LoadErrors_ATC.bad" -t "|" -r "\r\n"  "yyyy-MM-dd HH:mm:ss.fff" -E -S -U ATC_Login -P Password > "D:\SS\Error.log"

    But the execution fails everytime. The error log gets generated but its empty. Can someone help me with the syntax? Am I missing something here?

    Thanks in advance, 

    Thursday, August 14, 2014 10:58 AM