SQL Error Assistance Required
Budget: $10 – $30 USD
I am doing a bulk import from a CSV into a temporary table. I am validating the data already. I am at the point where I am doing the insert. I am getting the following error
An error occurred while validating the uploaded CSV file. Error Executing Database Query. [macromedia][SQLServer JDBC Driver][SQLServer]INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
I need a SQL Server Expert to help me resolve this error and any other error that may come up with getting the import to work.
You will not be given access to the database. I will share my screen using Google Meet and you will advise me what to do.
This really should be a quick fix if you know what you are doing. I am looking for a developer that has seen this type of error before.
Post the term #dbGuru7 in your bid so i know you read this.
I must be 100% satisified with the result.
An error occurred while validating the uploaded CSV file. Error Executing Database Query. [macromedia][SQLServer JDBC Driver][SQLServer]INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
I need a SQL Server Expert to help me resolve this error and any other error that may come up with getting the import to work.
You will not be given access to the database. I will share my screen using Google Meet and you will advise me what to do.
This really should be a quick fix if you know what you are doing. I am looking for a developer that has seen this type of error before.
Post the term #dbGuru7 in your bid so i know you read this.
I must be 100% satisified with the result.