: This is the primary IDE for designing SSIS packages. It is a specialized version of the Visual Studio 2008 shell included with the SQL Server 2008 installation.
: A simpler tool for basic data migration tasks that can automatically generate an SSIS package based on your selections. Core Development Workflow Microsoft SQL Server 2008 Integration Services ...
: Launch BIDS and create a new Integration Services Project . This generates a default package file with a .dtsx extension. : This is the primary IDE for designing SSIS packages
: Take advantage of the shared lookup cache feature in SQL Server 2008 to speed up parallel pipelines. Core Development Workflow : Launch BIDS and create
: In your data sources, only SELECT the columns you actually need to save memory and bandwidth.
: If the SSIS service and SQL Server are on the same machine, use the SQL Server destination instead of OLE DB for significantly better performance.
A typical development "piece" or project follows these steps: