February 16, 2010 at 12:03 pm
I have ONE Excel file that contains TWO worksheets. I have EXCEL datasources to each.
I then put each through a SORT of matching fields. I take the outputs of both of those sorts and INPUT them into a MERGE JOIN.
I take the output of the MERGE JOIN into a DATA CONVERSION where I simply convert each field so it will match the datatype of the database table.
The output of the DATA CONVERSION is then INPUT into a SQL Destination (this is where I get my error.
"Error1Validation error. Data Flow Task: DTS.Pipeline: input column "" (1102) has lineage ID 1035 that was not previously used in the Data Flow task. TestPackage.dtsx"
When I click on my SQL Destination the Restore Invalid Column Reference window pops up. It lists 10 INVALID COLUMN REFERENCES with LINEAGE IDs that I can NOT find.
I have looked through ALL the TASKS, Editors and Advanced Editors looks for LINAGE ID 1102 etc and can NOT find any of them?
...thanks in advance
February 16, 2010 at 12:50 pm
I think I fixed my problem. And I have NO idea what the "real" issue was.
I ended up DELETING my SQL DESTINATION and Rebuilding it from scratch. That seemed to "clear" the problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply