cancel
Showing results for 
Search instead for 
Did you mean: 

Error when writing 1000+ vstring to MSSQL

kksieski
Alteryx Certified Partner

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 

Moderator
Moderator

HI @kksieski,

 

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

 

Thanks,

Jessica Silveri
Customer Support Engineer
kksieski
Alteryx Certified Partner
@jessicas Hi thank you for responding. I just ran the wf using OLEDB and yes, I receive the same error.
kksieski
Alteryx Certified Partner
Hi @JessicaS, can we have a call to discuss this and come up with a solution please?
Moderator
Moderator

Hi @kksieski,

 

Sorry - I missed our first reply here.  I've moved this discussion over to 'data sources' from product ideas.

 

I'll create a case and reach out to you via email to discuss further.

 

Thanks,

Jessica Silveri
Customer Support Engineer