I'm trying to use dwloader.exe to upload data to PDW. However, the load fails even on a small example
C:\Users\vm>dwloader.exe -i "Z:\droptest.txt" -T databasename.dbo.droptest -R "C:\Users\vm\Desktop\input.bad" -U USERNAME -P "PASSWORD" -S 00.00.00.000
[2015-08-25 11:07:53] Starting Load
[2015-08-25 11:07:55] Connected to Microsoft SQL Server 2012 Parallel Data Warehouse (10.0.7365.0)
[2015-08-25 11:07:55] Load has started
[2015-08-25 11:07:55] Status: Running, Run Id: 76 - Total Rows Processed: 0, Total Rows Rejected: 0
[2015-08-25 11:07:56] Load error: Object of type 'System.Collections.Generic.Dictionary`2[System.Int32,System.String]' cannot be converted to type 'System.String[]'.
[2015-08-25 11:07:56] Load has Failed
In this example, I'm loading small text file containing
asjhasjas
asjdhsajd
08884883d
to the table that was created as
USE [databasename]
CREATE TABLE [dbo].[droptest](
a nvarchar(10)
)
All attempts to find resolution for this issue have led me to general discussions about type conversions in C++. But I'm not programming here anything, I'm just trying to use dwloader.exe "out-of-the-box". Thank you.