SQL Bulk load truncating data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2021 07:42 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2021 05:25 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2021 02:16 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2022 11:02 AM
Hey @Garrett do you solved that? Same problem here.
