Database Maintenance Tasks in SSIS. Tools for keeping your SQL indexes in check. By Eric Johnson; 05/10/2010; Do you have a large data import that leaves your indexes less than perfect?

Locate the data reader task icon and drag it to the control flow window. Double-click the icon to launch the advanced editor. Select "MySQLDB" in the Connection Manager column.

In the Control Flow you have an FTP Task that is available to your package and we will look at how it is configured. The FTP Task is pretty simple, but you do a have a few options to explore.

SQL Server's DTS (Data Transformation Services) was a very useful tool in copying or moving data from one server to another, as well as transforming a good bit of it on the way to a different ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in ... Switch to the Control Flow design window, ...