How to Convert to SSIS
- 1). Click "Start," "All Programs" and "SQL Server 2008." Select "SQL Server Management Studio." Connect to an instance of the SQL Server Database Engine. In the Object Explorer navigation pane, right-click the Data Transformation Services and choose "Migration Wizard."
- 2). Select your package migration destination such as Microsoft SQL Server. Type your server name. Select "SQL Server Authentication" to connect to the server. Input your username and password in the prompted dialog window.
- 3). Select a package on the Package lists in the Package Migration Wizard. Enter the password you used to create your package. The migration process will start. After the migration is completed, the migrated packages will be opened in SSIS.