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:
I received this error while running the "Basic Package" tutorial from Microsoft.
Post a Comment