• Thanks for all the comments!

    Matthew - Like Jack, I usually use the Konesans Trash Destination for an endpoint as well. I didn't mention it here. I also use the Script Component and the Derived Column transformations as dummy endpoints for data flow paths - basically anything that will succeed without configuration will do.

    :{> Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics