How to match datatable column with database column type

Hi Team,

I have created a database with below datatype columns
[DATA_TYPE
uniqueidentifier
varchar
varchar
varchar
datetime
varchar
varchar
varchar
varchar
varchar
varchar
datetime
varchar
varchar
varchar
]

I want to create datatable in UiPath with columns having same datatype as I am getting the below exception

Bulk insert: The provided columns in the DataTable do not match the column data types in the database.

Any help is highly appreciated!

Thanks in advance,
Akansha Sharma

you can try use GenericValue or use a referer to transform the information after

Hi Natanael,
I tried to use GenericValue but it is not working.

Thanks,
Akansha

can you share your flow?

Please share your workflow for more clarification

Hello @Akansha
I think this is because you are trying to add the varchar charector in datetime or something like that. can you share the workflow. or check the columns are having equal number and have same data types with same column name or index.

Hi All,
Thank you for your support.
Issue is resolved when I added the uniqueidentifier and date time column separately.

Thanks,
Akansha Sharma

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.