I have a csv file of 1000 rows, need to insert these data into SQL Database.
Now my concern is:
- How to Validate the length of data present in a Column of csv file to database table whose table lengh is fixed, for example create table asset
(Asset ID int,
but the length of character in csv file is not fixed sometimes its value exceed i.e. more than 100 or 200 characters, so need to validate data before insert to database. Is it possible to do this? If possible then please share steps/workflow to do the same.
Thanks in advance.