Skip to content
Advertisement

Text Qualifier syntax in PDW dwloader

I am using dwloader utility to load data into PDW. My dwloader syntax is given below:

    dwloader.exe  -M reload -b 200000 -i dDevelopmentSourceFACT.TXT -T Test_DB.dbo.FACT_LOAD -R dDevelopmentBadFACT_LOAD.bad -t "," -fh 1 -r rn -D "yyyy-MM-dd" -E -S 10.1.1.19 -U Devl_User -P Password1> "dDevelopmentLogFACT_LOAD.log"

Pause

I got the data loaded into the table. But all the varchar columns have data within double 'quotes'. My text file is commma delimited. Any idea on how to include the text qualifier in the above syntax?

Advertisement

Answer

I figured the answer myself. Including ” -s 0x22″ in the command above will escape the double quotes.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement