Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Error Expand / Collapse
Author
Message
Posted Friday, August 22, 2008 12:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205
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, :P
My Blog:

http://venkattechnicalblog.blogspot.com/
Post #557074
Posted Wednesday, September 17, 2008 3:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 19, 2008 4:12 AM
Points: 1, Visits: 5
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

Post #570838
Posted Wednesday, September 17, 2008 3:13 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205

Getting response after 25 days.. I have successfully completed the project and its deployed.

Anyway, thanks for your response.


Thanks and Regards,
Venkatesan Prabu, :P
My Blog:

http://venkattechnicalblog.blogspot.com/
Post #570847
Posted Thursday, July 29, 2010 8:53 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 70, Visits: 610
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 !!
Post #960775
Posted Friday, October 18, 2013 11:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 2, 2014 9:00 AM
Points: 3, Visits: 37
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.
Post #1506278
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse