How to insert a datatable into SQL Server database using Uipath database activities?

There is a insert datatable activity, you must make sure all columns and datatypes are matched.

So the datatable in uipath and database must have the same number of columns etc.

A good way to ensure the dt is correct format is to do a select statement om the dt.

Select top 0 * from dt. This returns a blank datatable with the headers.

5 Likes