If you are looking to generate a verified text output via SSIS, you generally follow these steps: Data Flow Task