TABLE A BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001 NULL NULL 10005899 en-US 1561001 NULL NULL 10005899 nl-NL 1561001 35023080 NULL 10005899 en-US 1561001 35023080 35023080 10005899 en-US TABLE B BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001...

Guys, im in need of an urgent answer to this issue. My DTS package converts empty string to NULL upon transformation, how can i prevent this so that i will retain the value of empty string to my field? Additional Info: 1.) When i use a T-SQL script, the value of empty string is retained after replicating...