A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Monday, February 23, 2009

Validation error. An input column with the lineage ID , referenced in the ParameterMap custom property with the parameter on position number 1, cannot be found in the input columns collection

A great deal of thanks to Catherine Eibner for her blog post
http://blog.cybner.com.au/2008/03/working-with-complex-lookups-in-ssis.html

We had used date ranges in lookups here before but one coworker did
"something" to a package that just kept breaking. I ran into the same
issue (Validation error. An input column with the lineage ID ,
referenced in the ParameterMap custom property with the parameter on
position number 1, cannot be found in the input columns collection)
and luckily came across her posting. The short of it, in case her
post goes away, is that even though you are explicitly mapping values
in the advanced tab, you must map it as well in the Columns tab. The
Columns mapping will be discarded but it must be done. *shrug* These
are the mysteries of SSIS and simply need to be acknowledged. Read
her post, far better than this one but I wanted to link to it as there
weren't many hits from google when I searched for it.

1 comment:

Mak said...

I received this error while running the "Basic Package" tutorial from Microsoft.