• Have you been through either the samples for SSIS or Books OnLine (BOL) (see here for a 'how-to' for this exact topic)

    Steve.