- 1). Open the Visual Studio software from the ".NET Framework" program group on your development computer.
- 2). Click the "File" menu item and select "New." Click "Project" to start the new project wizard. Choose "Integration Services Project" in the list of project types.
- 3). Type a name for the new SSIS project and click "OK." The project is created and Visual Studio opens to the main template of the project. To configure SSIS you must connect to a database server.
- 4). Right-click "SSIS Packages" in the navigation panel and click "New OLE Connection" to open a configuration window.
- 5). Type a name for the connection in the first text box. Select your SQL Server in the drop-down window and type your username and password to access the server.
- 6). Click "Package Configuration." Type a name for the connection string in the text box. This is the connection string used to connect to the SSIS package from your Visual Studio projects. Click "OK" to complete the configurations.
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
Prev Post