InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 01:10:56 GMT20http://www.sqlservercentral.com/Forums/Topic1381106-392-1.aspxCheck the initial value before the insert:[code="sql"]DBCC CHECKIDENT('myTable',NORESEED)[/code]If it is not 1, your creation script has initial value that is not 1.To reset identity to start from 1 use this:[code="sql"]DBCC CHECKIDENT('myTable',RESEED,0) [/code]But it is better to fix the creation script.Mon, 05 Nov 2012 18:04:57 GMTVedran Kesegichttp://www.sqlservercentral.com/Forums/Topic1381106-392-1.aspxCheck the source where the data is coming from in the package and your transformations, if your inserting a column from the source into the identity column in the destination it will take what ever the values are from the source, it wont start from 1.Mon, 05 Nov 2012 08:19:13 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1381106-392-1.aspxhi,my identity column should start with 1,1 .but when i insert data from package , it starts 1133.even if i drop table and create again and insert data from package,it starts with 1133any helpMon, 05 Nov 2012 08:17:47 GMTharri.reddy