Bulk insert No value given for one or more required parameters

[omar_ismail]

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

[Anil_G (Anil Gorthi)]

@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

Hope this helps

Cheers

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

@omar_ismail

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

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

[Anil_G (Anil Gorthi)]

@ABHIMANYU_THITE1

Please check this

Insert

Bulk Insert

Cheers

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Thank you @Anil_G !

[omar_ismail]

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

[Anil_G (Anil Gorthi)]

@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

[AdityaVN (Aditya Vaddiraju)]

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

[omar_ismail]

database: SSMS SQL