Can someone help pls. I am trying to move an Excel source to Destination but it says = Failure inserting into the read only- column

You need to check your Excel destination , Maybe they have set some columns READ only, You can't write to them. Check if Your destination Excel has some MACRO written on it , those are not letting you write new data. EDITED --Sorry: Miss understood your question, Go with Nitesh Suggestion. Thanks http://sqlage.blogspot.com/

What is the destination? In case of some database check is that column is defined as identity column in the destination tables and enable identity insert on. Ex: In SQL Server you can use Set Identity_Insert TableName On Nitesh Rai- Please mark the post as answered if it answers your question

The destination is to OLE DB.

The destination is to OLE DB. Are you inserting into a table or a view? If its a view is that column derived / calculated? If its a table Nitesh is right that you may be trying to insert an explicit value into an IDENTITY column and the IDENTITIY_INSERT option is set to OFF. If that is your intend then on the OLE DB Distination Editor "Connection Manager" page/screen set IDENTITY_INSERT OFF and it should work.Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends