If you've worked on any reporting solution using SSRS, you may have been able to take advantage of subscription feature. Subscriptions allow you to schedule a repeating or one time request to receive a specific report at a specific time. Now, you create the subscription in a very simple, straight-forward interface on the report manager, but what you're actually doing is creating a job on your report server with a schedule associated with it. Just like a job you would create for you SSIS packages...
Read More
If your business is in the process of converting old DTS packages to new SSIS packages, you will quickly notice that many of the components used in DTS are not easily converted to SSIS native components. Something you may also want to keep in mind is that even the easy to convert components might have content within them that will need some modification. For example, a DTSExecuteSQLTask from you DTS package can easily be converted to a native SSIS component (Execute SQL Task). However, there are...