I am converting an Access Database to SQL. My problem is that I have
many different source fields I want to put in to one field
(CaseNotes,Notetext) in the DTSdestination but I want each to create a
new recordset. Right now the last transformation to take place is the
only one I can see when executed. Also it is creating a record for
each case number even if null even though I used and IF THEN statement.
I want to be able to have many rows for each case if the data is there
or nothing. Here is the code I have so far for one transformation:
Any and All suggestions would be most appreciated.

Thank you,

Amy