Hi ,
Iam having the csv file where i am trying to do for bulk insert in to an table.
Sample csv file
2011-04-21 04:01:07,ATime,Tes,Mine,scot.txt,3762.99,10128.2
2011-04-21 04:01:20,ATime,Err,Mine,scot.txt,5762.94,50128.2,234
2011-04-21 04:01:20,ATime,Err,Mine,no.txt,7622.94,10128.2
2011-04-21 04:01:20,ATime,Err,Mine,yes.txt,0,6,103
The CSV file file have 7 columns in first row and in 3rd row but in other rows it may have 8 columns or 7 columns.
The xml format file is as
<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharT ...
Go to the complete details ...