I am trying to insert data from SQL server into the Sybase DB through DTS(Data Transformation Service).
It gives me an error in the identity column. When i tried setting the identity_insert for that table to be ON and tried inserting my values which is also a sequence of numbers, it gives me an error saying that the data cannot be inserted when the identity_insert is set to OFF. But fortunately with this command,
set identity_insert <table_name> on
I never got any error and so i thought it is set to ON now.. But the error contradicts it.
URGENT help required on this.
Any timely help would be greatly appreciated.