cancel
Showing results for 
Search instead for 
Did you mean: 

Error when writing 1000+ vstring to MSSQL

My wf contains fields of v_string with char sizes above 1000. When Alteryx attempts to write to MSSQL tables, either to create or append, I receive the Alteryx error "Error SQLBindParamter: [Microsoft][SQL Server Native Client 11.0]Invalid precision value".

 

I cannot find any resources to fix this issue. I have had to make a workaround process to limt the Alteryx field sizes to 1000 chars or less, insert into a temporary table in MSSQL, and then compose into the final fields. This adds needless complexity.

 

In the screenshot, the Alteryx version number and ODBC driver version are clearly shown.

 

 

 

alteryxBug.PNG 

2 Comments
Moderator
Moderator
Computers
Regular Expressions
Status changed to: New

HI @kksieski,

 

If you connect as OLEDB do you get the same error?

 

Thanks,

kksieski
Alteryx Certified Partner
@jessicas Hi thank you for responding. I just ran the wf using OLEDB and yes, I receive the same error.