Import Excel (xls) into SQL Server 2012 using SSIS -


i have issue in importing data excel sql server using ssis

issue works when run package again (supposingly append more records in table shows error)

could let me know need do? need configure package again or set on database ?

here see on first run of package

http://i.stack.imgur.com/ylnbx.jpg

data have been imported correctly in sql

http://i.stack.imgur.com/lwdgi.jpg

but when run again show error, until truncate table.

http://i.stack.imgur.com/bx4t7.jpg

basically sqlite database used save data.android provides several ways store user , app data. sqlite 1 way of storing user data. sqlite light weight database comes android os.

you can see link here.which contains code import exel sheet sqlite database.

and code that:

fileinputstream = new fileinputstream("excel file path in sdcard"); hssfworkbook  wb = new hssfworkbook(is); hssfsheet sheet = wb.getsheet("test");  iterator<?> rowiterator = sheet.rowiterator(); int index = 0; while (rowiterator.hasnext()){       hssfrow hssfrow = (hssfrow) rowiterator.next();       if(index++ != 0){           //in stage have storing each cell database           util.inserrdatatosqlitedb(dbmanager, hssfrow.getcell(1).getstringcellvalue(),   hssfrow.getcell(2).getstringcellvalue()       }  } 

which serioslly helps me when need 1 , see this link


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -