Hi,

I have amended the code and verified it executed without errors. Yes, I will agree the column name conventions are not appropriate.

CREATE TABLE #table1

(table1id INT IDENTITY(1, 1),

name VARCHAR(40),

department VARCHAR(30),

city VARCHAR(30),

modifieddate...

Hi John,

The Multiple Join condition returns multiple lines from #table1 for each #Table2. Currently I am using these two joins  query separately, because I can using RowNumber to eliminate multiple...

• This reply was modified 4 years, 7 months ago by  Sangeeth Raj.

Hi,

@scottpletcher, @Grant Fritchey: I am really glad for your messages, I have figured it out how to handle this scenario as follows

CREATE TABLE #TableA (Type int, Col1 int,...

Hi,

My apologies for duplicate post, Initially I have posted this thread in 2019, then I have realized it might be in-appropriate to post in 2019 forum when I am working...

Hi 

I am glad for your message, Being a newbie in SSIS, I am avoiding Script task for two reason, I don't know script and in my office laptap...