SQL Bulk load truncating data

[Garrett]

Hi Community,

I am trying to SQL Bulk Load with the Create Table option. When this runs it is erroring on string truncation. I do not understand how to use the Mapper with only one side as a second input into the pipeline. I do not want to have to map all the fields/objects I have 1900+ fields and 167+ tables.
SQL Insert is inserting with Varchar(8000) and this doesn’t work because it is not supporting unicode characters.

Thanks for any help.

[mohit]

Hi @Garrett

I had the similar requirement too and in this case I used the SQL Server Execute snap before all other snaps in the pipeline to create the table with desired data types. And after that I loaded the data.

[Garrett]

Do you have a sample pipeline?
How do you determine the fields dynamically? Eg how do you create the table if you don’t know ahead of time what the fields are?

[Marley_Bacelar]

Hey @Garrett do you solved that? Same problem here.