[font="Tahoma"]

Hello John,

I would like to join these record sets using the patientid and the rid columns.

[/font]

Hi Thanks for your response.

I already have the logic for finding the month start date and end date. Can you please help me in setting these values to the parameter.

My...

If you are pulling the records from the same table, i do not see the reason why you are going for the sub query. You can pull the records without...

Please provide the table structure and the expected output clearly

Thanks for your responses friends. I found that we must use aggregate function in the Pivot operator and i just used Min function just to retrieve the row and it...

Thanks for your response. I too thought of using Pivot for this requriement. However, I am not going to do any aggregation. I just want to convert the column values...

We need not use Left Join as we are looking for records only for the account which is present in table A. So we should use Inner Join to pull...

As mentioned in the error message, it is due to the conversion of the data. Just use quotes to enclose data as suggested by Suresh and it should work.

Hello friends,

The issue was due to the fact that i was using the variable updated by the Rowcount Tran in the same DFT. We cannot use the variable until the...

I created this package just to test the functionality of the Row Count Transformation and i dont want a destination adapter. So i am using Union All as a temporary...

Thanks for your response friends..

Thanks for your response.

Yes, i tried this option and its working fine without any issues. But i have to move 34 tables from source to destination. So i believe it...

Hello Friends,

Thanks for your response. Yeah, i know that we can achieve this using other options as well. However, i would like to know if there is an option to...

Thanks for ur response Lutz.. That was really helpful

Hi Lutz,

The link is not opening. Can u give the complete link.

Regards,

Murali