This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject

We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Change Packet Size in OLEDB

psyrio
9 - Comet
‎10-04-2017 06:29 AM

Hello,

 

I want to change the Packet Size into the patch of my OLEDB connection to SQL Server but I don't find the property can you help me please ?

 

Regards,
Psyrio

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
AngelaO
Alteryx
Alteryx
‎10-10-2017 09:24 AM

From the Input Data tool, click the down arrow for Connect a File or Database.  Click Other – OleDB.  Be sure to pick SQL Server Native Client 11.0.

 

Click ALL and there is an option for Packet. 

 

Connexion Database into InDB Input or Input classic.

 

 1.JPG

 

You can change the PacketSize to a maximum of 32767.    Try changing in the useralias.xml or systemalias.xml files…

 

C:\Users\user\AppData\Roaming\Alteryx\Engine

 

[Alteryx Install]\Engine\SystemAlias.xml

Customer Support Engineer
Reply
0 Likes
psyrio
9 - Comet
‎10-10-2017 10:43 AM

Hello,

 

It's works thank a lot.

 

Regards,
Bruno

Reply
0 Likes
Labels