I was tried to insert record as in Insert into DB.zip (22.2 KB) this code but its not working, in this insert statement has following difficulty
-
It added extra space in value because value get from text file
-
If field was empty then we have to set that as ‘NULL’ for that i have to apply IF within For Each, but i already used 4-5 times For-Each loop
-
The another point is in real text file contain 60k - 70k records that mins it took more time to execute
-
At the time of Insert query writing how can you sort-out which value is in single cote beacuse if you apply loop it apply single cote on NULL
-
I also tried bulk upload using ‘Insert’ activity but it cant work
Please provide the solution on that or another way (another logic) to insert record from pipe separated text file into DataBase Table
Table structure tatacapital_mis_tbl_openitem.zip (1.2 KB)