Unable to copy IDENTITY column

Navee,

How big is your table?

I would recommed you to read the performance section of the below link

http://ift.tt/1fv1TZs

Even you can try SSIS Import and export wizard.

SET IDENTITY_INSERT [DESTINATION_DBNAME].[dbo].[DESTINATION_TABLENAME] ON

INSERT INTO [DESTINATION_DBNAME].[dbo].[DESTINATION_TABLENAME](col1,col2,col3)

SELECT col1,col2,col3 FROM [SOURCE_DBNAME].[dbo].[SOURCE_TABLENAME]

WHERE Column_Name = 'SI'

SET IDENTITY_INSERT [DESTINATION_DBNAME].[dbo].[DESTINATION_TABLENAME] OFF

Answer to your question

http://ift.tt/1mNT3LB

--Prashanth