Using SSIS's graphical designer, the task is straightforward, if not entirely intuitive. Create an Integration Project with a Data Flow Task Create a new project.

Microsoft SQL Server Integration Services, or SSIS, allows you to extract data from databases, including. ... Locate the data reader task icon and drag it to the control flow window.

Context is important when selecting an option from the SSIS toolbox menu. The active window context must be changed by clicking anywhere on the Control Flow page when a DTSX file is open. Once you ...