Question CSV Bulk insert issue

Hi,

I have CSV file which I want to insert into db

If I try with Action Process LOAD File to Mssql (with BULK) template it gives me below error
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot bulk load. Invalid number of columns in the format file "e:\devl\IMS/SSIM07L.fmt".

If i try with Action Process LOAD File to Rdbms template then It work fine.

I am attaching screen shot of error and also sample file.
Please help me to resolve error.

Let me know if any other details required.

Regards,
Prashant

Template Action Process LOAD File to Rdbms does not use Bulk Load. It uses Select from the source and insert to the destination
Probably you have an errors at the metadata. Check if you used whitespaces in the names of the fields.
Moreover you can compare fmt file that Stambia generates with fmt file of bcp out.

Hi,

To test my mapping is correct or not, I am using Template Action Process LOAD File to Rdbms.
For bulk load i am using Template Action Process LOAD File to Mssql (with BULK) template which is giving me error.

also If there is errors at the metadata then how could my mapping executed successfully when i executed my mapping with Template Action Process LOAD File to Rdbms. and I have check there is no whitespace in the names of the fields.

Also your suggestion for compare fmt file that Stambia generates with fmt file of bcp out, I will check and get back to you.

Thanks for help.

Regards,
Prashant