Integration Services ships with many useful tasks. Microsoft tried to make the task user interfaces and working models similar across tasks so that they're easier to learn and use consistently. The array of stock tasks is impressive and powerful. Yet, if the offering still doesn't cover your needs, the Script Task is available to quickly and easily implement your own task behavior. Further, you have the ability to easily build your own custom task if you want. |