• OK.

    The package runs fine on the production server when I run it from SSIS

    Can you elaborate on exactly what you mean here - what steps are you taking?