I had excel file A.XLS
SNo PersonName/FatherName/RationCardNo
1 rajaiah,s/o anjaiah,R100
2 RAMARAO,s/o Somaiah,R101
3 Laxmaiah,s/o anjaiah,R102
4 anjaiah,s/o ramaiah,R103
I want to transfer the data from excel file to sqlserver 2005(PersonDet table)
using with separate comma using ssis2005
In sql server 2005 I had PersonDet table
PersonDet
---------
SNo
Personname
FName
RCardNo