I am getting an error reading: Input column "Description" (1873) has a lineage ID of 2825 that was not previously used in the Data Flow... The Excel input source file is the same as the previous source files... I am not sure why it is causing an error? Mr Shaw

Hi, Please see the following post on similar topic. Hope this helps http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fbd46fea-b001-4465-a483-8fd35d87bc8aMSBI Developer

I think the problem could be the destination column. What is the maximum amount of character I can have in a NVARCHAR (max) column?Mr Shaw

No, as far as I remember I got this message after I copied and pasted a component(s) or a DFT. So just delete and recreate it or make a new one from scratch.Arthur My Blog

No, as far as I remember I got this message after I copied and pasted a component(s) or a DFT. So just delete and recreate it or make a new one from scratch. Arthur My Blog The file is part of a group of files which is read in a Loop Container. Making a seperate data flow just for one file is not really the right approach.Mr Shaw

Mr Shaw, based on what I read the error occurs when the package runs onto this particular file only. Is this statement correct? If you answer yes, then of course, if you'd examine this Excel file you could find that it has a different metadata (e.g. a new column, by the way the error message you got is very eloquent to this regard). Now to process this file (which is different) I am afraid you do need to create a separate piece of logic (DFT).Arthur My Blog