Cream Cheese Cranberry Salad

raspberry Jell-O1 1/2 cups boiling water1 (20-oz.) can crushed pineapple1 (14-oz.) can whole berry cranberry sauce3/4 cup cranberry juice1 cup toasted pecans, chopped1 (8-oz.) package cream cheese, softened1/2 cup sugar1 cup sour cream