No Table Chosen; Please select a table from data source

[ShubhamDhorajkar001]

Hey Team, I am getting issue with output Data activity where I am writing data to the database with dynamic data input, does anyone know workaround to get this sorted out?

[jdminton]

The message is indicating that you have not assigned a table to write to. Can you include the configuration window for the output data tool? You can blur or cut the image to obscure the server address, if needed.

[ShubhamDhorajkar001]

Hey jdminton, this is my configuration 

And here is my SQL Details 

'odb:Provider=MSOLEDBSQL.1;Password='+[Password]+';Persist Security Info=True;User ID='+[Username]+';Initial Catalog='+[DatabaseName]+';Data Source='+[ServerName]+';Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=UK007561;Initial File Name="";Use Encryption for Data=True;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=True;Application Intent=READWRITE;MultiSubnetFailover=False;Use FMTONLY'

[jdminton]

At the end of that string should be three pipe characters ||| followed by a starting table name. You need something there to start for Alteryx to be able to update the table name as you are requesting. Set up the connection again and when it asks for a table name, type in anything. I used test in my example.