Bulk insert No value given for one or more required parameters

Help Something Else
1

Hi all,

I am trying to upload my data to SQL through bulk insert activity however it keeps giving me the below error in the screenshot

image
image914Ă—293 18.8 KB

1 Like
2

@omar_ismail

Can you confirm which drivers you are using by default odbc are supported and try getting the latest version of odbc drivers as bulk insert uses standard schema calls …so its better to use compatible version

image
image828Ă—714 76.1 KB

Hope this helps

Cheers

1 Like
3

Hey @Anil_G thanks for sharing it. can you please provide this documentation link, I would love to go through it

1 Like
4

@ABHIMANYU_THITE1

Please check this

Cheers

1 Like
5

Thank you @Anil_G ! :slight_smile:

1 Like
6

I am not sure that I get ur idea if u can elaborate and what is the meaning of odbc?

7

@omar_ismail

So basically whenever you connect from UiPath to a database you use database activities…but in turn on the backend UiPath activities use a connection with oledb or odbc which are database connection providers to connect any external system with database…now you need drivers for that…and one such drivers are odbc drivers which can be used for your database activities to work…

For more info on the same

What is an ODBC Driver?.

Hope this helps

cheers

8

what is the data base you are using ?
postgresql or ms sql?

10

database: SSMS SQL