The SSIS management interface is not attached to the server by default, and this is somewhat mysterious to those who worked with SQL 2000. You need to attach the SSIS to the management studio. This you implement as shown in the next picture by clicking on the drop down menu right next to Database Engine and choosing Integration Services.
After this you provide the authentication information which will take you to the next screen. Here you highlight Hodentek after expanding the node, and click OK.
This adds the SSIS management objects to the server nodes as shown. The package you created will be in the MSDB folder of the Stored Packages. You may recognize the name that was given to the package at the time it was created. From here on you can do a variety of things with the package as shown.
Only a very small part of the integration services as exposed by the SQL Server Import/Export wizard was described. It is shown that the two way transfer of tables is very easy. Although a large number of screen shots were shown all of it can be accomplished in under 15 minutes. The user interface exposed by the wizard is very user-friendly, and several new features described in the tutorial makes it easy to use, providing a very useful and handy tool.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
