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.
Never figured out the issue. Just switched to a "Delete Data and Append." Never could get the "Update..." output options to work. I received a link to the help page for outputs, but it's lacking detail (https://help.alteryx.com/11.3/index.htm#Output_Options.htm). The information assumes the user has advanced knowledge of the writing to SQL Server. In my mind the update option should work, but can only write to the DB with "Delete Data and Append"
thanks for the knowledge. - actually the issue i had has been solved by changing all the data size to 255 of v-w string data type. think the default data size for this data type is too big for any SQL server.