How to match datatable column with database column type

RPA Discussions
, , , , ,
1

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

2

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

3

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

Thanks,
Akansha

4

can you share your flow?

5

Please share your workflow for more clarification

6

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.

7

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

Thanks,
Akansha Sharma