none
Data loading using DWloader

    Question

  • 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 10.11.12.13 -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 7:12 AM

All replies

  • Any sort of help would be really appreciated. Thanks.
    Thursday, August 14, 2014 9:09 AM
  • Hi,

    I'm not sure if this is the correct forum for this question. I have installed Microsoft Visual Studio Professional 2013 Version 12.0.30723.00 Update 3. I am trying to use the dwloader utility for pdw for data loading and it keeps failing. 

    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 10.11.12.13 -U ATC_Login -P Password > "D:\SS\Error.log"

    But the execution fails everytime. The error log gets generated but its empty.

    It was after sometime I realized that I do not have dwloader.exe in the below folder:

    C:\Program Files\Microsoft SQL Server Parallel Data Warehouse\100\

    In fact, there is no folder by the name Microsoft SQL Server Parallel Data Warehouse in the Program Files. Could this be a problem? Please help.

    Thanks in advance.

    Thursday, August 14, 2014 11:48 AM
  • Hello Triumph Spitfire,

    I didn't find the following folder "C:\Program Files\Microsoft SQL Server Parallel Data Warehouse"after the installation of Visual Studio. So your issue is not related to Visual Studio Setup forum. I will move your case to "sql server data warehousing" which seems more related to your problem.

    Best regards,



    Barry
    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, August 15, 2014 2:56 AM
  • Hi Triumph,

    Thank you for your question. I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    If you have any feedback on our support, please click here.


    Elvis Long
    TechNet Community Support

    Monday, August 18, 2014 7:53 AM
    Moderator
  • Hi Triumph,

    By default, there is ClientTools-amd64.msi shipped within HST01 under C:\PDWINST\ClientTools, you can install the tools in your environment. Anyway, please download from the workspace.

    https://filetransfer.support.microsoft.com/EFTClient/Account/DTM.exe 

    Username:    

    ea5f8954-db10-404a-86a5-781b2f18f332

    Password:

    y_2SG8b=

    Meanwhile, here are more information about dwloader.exe.


    dwloader.exe { -h | -v }
    
    dwloader.exe 
        {
            { -U login_name  -P password  }
            | -W
        }
        [ -f parameter_file ]
        [ -S target_appliance ]
        { -T target_database_name . [ dbo ] . table_name } 
        { -i source_data_location } [ <source_data_options> ]
        { -R load_failure_file_name } [ <load_failure_options> ]
        [ <loading_options> ]
    }
    
    <source_data_options> ::=
    {
        [ -fh number_header_rows ]
        [ < variable_length_column_options > | < fixed_width_column_options > ]
        [ -D { mdy | myd | ymd | ydm | dmy | dym | custom_date_format } ]
        [ -dt datetime_format_file ]
    }
    
    <variable_length_column_options> ::=
    {
        [ -e character_encoding ]
        -r row_delimiter 
        [ -s string_delimiter ]
        -t field_delimiter 
    }
    
    <fixed_width_column_options> ::=
    {
        -w fixed_width_config_file 
        [ -e character_encoding ] 
        -r row_delimiter 
    }
    
    <load_failure_options> ::=
    {
        [ -rt { value | percentage } ]
        [ -rv reject_value ]
        [ -rs reject_sample_value ]
    }
    
    <loading_options> ::=
    {
        [ -d staging_database_name ]
        [ -M { append | fastappend | upsert -K merge_column [ ,...n ] | reload } ]
        [ -b batchsize ] 
        [ -c ]
        [ -E ]
        [ -m ]
        [ -N ]
        [ -se ] 
    }
    

    --Load over Ethernet
    dwloader.exe –S 10.192.63.148 -U mylogin -P 123jkl -f /configfiles/loadparamfile.txt

    --Load over InfiniBand to appliance named MyPDW
    dwloader.exe –S MyPDW-SQLCTL01 -U mylogin -P 123jkl -f /configfiles/loadparamfile.txt

    Monday, August 25, 2014 2:47 AM