Create a SSIS package

Basic steps to create an SSIS package (old DTS) to copy data from one database to another in SQL Server 2008:

Great link for the basic steps http://it.toolbox.com/blogs/coding-dotnet/creating-a-ssis-package-24699

However to truncate the tables before filling them with the above package:

1. Drag a Execute SQL Task into the control Flow window.
2. Double click and set the connection
3. Enter SQL Statement
4. Drag green line to the data flow task or the next step to run.

Point to Note: This tool is similar to Reporting Services where you create a project and then can have many packages within the project. Each package can then share the connections within the Data Sources folder.

Enjoy!