SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Error


SSIS Error

Author
Message
Venkatesan Prabu
Venkatesan Prabu
SSC-Addicted
SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)

Group: General Forum Members
Points: 458 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, Tongue
My Blog:

http://venkattechnicalblog.blogspot.com/
snowman_84_4
snowman_84_4
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 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
Venkatesan Prabu
Venkatesan Prabu
SSC-Addicted
SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)SSC-Addicted (458 reputation)

Group: General Forum Members
Points: 458 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, Tongue
My Blog:

http://venkattechnicalblog.blogspot.com/
JasonYousef
JasonYousef
Old Hand
Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)

Group: General Forum Members
Points: 343 Visits: 676
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 !!
mayank.visnoi
mayank.visnoi
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 78
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search