SSIS Error
-
I am having two source, Sybase and sql
Sybase table columns
-------------------
report_id name1
SQL table columns
------------------
report_id name2,valu
I have specified sybase as one data source with report_id as sorted one and its type dt_numeric.
Specified SQL as another source with report_id type is float type.. placed a data conversion operator to convert into dt_numeric.. placed a sort operator with sort option on report_id...
Added merge join to add both the sources, am getting an error.
TITLE: Microsoft Visual Studio
------------------------------
Both inputs of the transformation must contain at least one sorted column, and those columns must have matching metadata.
------------------------------
or sometimes am getting this error,
lineage ID "report_id" 5484 that was not previously used in the Data Flow task.
-------------------
No input columns found. At least one input column must be mapped to an output column.
---------------------------------------------------------------------------------------------
I have tried with sample tables.. its working fine.
Please help me resolve this problem.
Regards,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/
Thanks and Regards,
Venkatesan Prabu,
My Blog:http://venkattechnicalblog.blogspot.com/
-
The solution for the error:
TITLE: Microsoft Visual Studio
------------------------------
Both inputs of the transformation must contain at least one sorted column, and those columns must have matching metadata.
------------------------------
BUTTONS:
OK
------------------------------
The reason why you are getting this error is that the data types of the merging columns are different. Set both of them the same type by setting the data-type property in the Advanced Editor
-
Getting response after 25 days.. I have successfully completed the project and its deployed.
Anyway, thanks for your response.
Thanks and Regards,
Venkatesan Prabu,
My Blog:http://venkattechnicalblog.blogspot.com/
-
I'm having the same problem, can you tell what was your solution!!
my data type are the same...!
Thanks
----------------------
my mistake, data type wasn't matched !! duh !!
-
Hi Masters,
I am having the same issue,
I am using one Flat file source and other is Excel source, want to merge one more column which is in Excel file, and in both of the sources Account_Id column are same,
Although both were using diff Data type but UI used Data Conversion and make them same,
Also used Sort on both of the sources on Account_Id column.
but still I am getting the Lineage Id issue.that I am using the Lineage Id which is not previously used.
Can you please suggest me that how you solved this problem, would be really Appreciate.
Thanks in Advance.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply