I'm pretty new to .net code. I was using C# code inside script task-SSIS
I'm using bulk copy task to pull data from oracle to sql db based on MemberID. I have got member id column in table which is having all integer values.. Member ID ex: 123456 but i have data in oracle like 123456A, i need to append letter in the end of each member before search in oracle and letter is not fixed..i have to add A to M to each member in the end.Any help greatly appreciated sSQL_For_Incoming_MemID parameter is the query fetching id's from sql.. EX: Select distinct MemberID as HICN from table thanks