Post reply

SSIS Error

  • August 22, 2008 at 12:08 am

    #197461

    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/

  • September 17, 2008 at 3:05 am

    #872869

    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

  • September 17, 2008 at 3:13 am

    #872877

    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/

  • July 29, 2010 at 8:53 am

    #1199850

    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 !!

  • October 18, 2013 at 11:45 am

    #1659811

    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