I copied the  above sql ( as it is )....in a ssis variable and called it from execute sql task....it is still not working 🙁

sorry...i updated the question now. with correct example.

Thanks....This join works for me.....as i am looking for both results either join on t1.a =t2.a or t1.b=t2.b.....this returns results , when either of the fields ( t1.a or t1.b)...

• This reply was modified 1 year, 4 months ago by  komal145.
• This reply was modified 1 year, 4 months ago by  komal145.
• This reply was modified 1 year, 4 months ago by  komal145.

For DB2 connection , you need to set a odbc connection. Install db2 drivers first on sql server set up.

You need to set up/Create the node for db2.

Thanks. It worked.

I used script task and cahnged the LF TO CRLF. Thanks. This process is permanent going forward

Thanks working.

Still same issue. Is it how you pass environment varibles correctly? I just specified folder name ? do we need to give path sepcifically?

• This reply was modified 2 years, 7 months ago by  komal145.

Thank you. I was able to update my logic based on the query you provided. Is there a way in your query to get the relationship for those i gave...

• This reply was modified 2 years, 10 months ago by  komal145.

Thanks for the Reply. I was able to validate data using Regular expressions , since we have oracle source data Using Script component as transformation in SSIS. It is way...

Thank you everyone for the reply.

;WITH CTE AS (

SELECT E.E_ID , E.D_ID, E.salary,Row_number() over (partition by d_id order by salary desc) as row

FROM Employee2 E

)

SELECT CurrentRow.E_ID , CurrentRow.D_ID , Nextrow.Salary as othersalary

from CTE CurrentRow

left JOIn...

Thank you. it works.

Yes , it is is one row for one loan.

Here is how i am looking for status to be in second table. If there is no entry in table 1 for a loan Then i need status to be...

• This reply was modified 5 years, 6 months ago by  Steve Jones - SSC Editor.