To | Do This |
---|---|
Open the SSIS project | In Windows Explorer, navigate to the project, and then double-click the file to open it in BIDS. In Solution Explorer, double-click a package to open it in design mode. |
Create a data flow task | In BIDS, on the Toolbox menu, in the Control Flow Items group, drag Data Flow Task onto the Control Flow design surface. |
Edit an object | In BIDS, on the design surface, double-click the object, and then change its properties as needed. |
Create a data adapter | In BIDS, on the Toolbox menu, in the Data Flow Sources group, drag Flat File Source onto the Data Flow design surface. |
Add a connection manager | In BIDS, on the Data Flow designer, double-click the data adapter. In the Editor dialog box, click New to create a new connection manager. Specify the file name, the file properties, and the file format. |
Add a Conditional Split transformation | In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Conditional Split onto the Data Flow surface. |
Add a Derived Column transformation | In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Derived Column onto the Data Flow design surface. |
Add a Multicast transformation | In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Multicast onto the Data Flow design surface. |
Add a Destination data adapter | In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag SQL Server Destination onto the design surface. |
Create a task | In BIDS, on the Toolbox menu, in the Control Flow Items group, drag Data Flow Task onto the design surface. |
Create a flat file | In BIDS, on the Toolbox menu, in the Data Flow Sources group, drag Flat File Source onto the design surface. |
Add a lookup transformation | In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Lookup onto the design surface. |