Change the designer tab to "Control Flow" and right click the Prepare 2k5 SQL Task which brings up this drop-down menu.

Figure 46

From the drop-down, click on "Execute Task."  Make sure you only click on this particular control.  The program runs and you should see a display as shown in Figure 47.  Green shows it ran OK and red means it ran with errors.

Figure 47

You can also get an idea of how the Execute SQL Task executes when you tab to Progress with the green arrow on its left.  It takes under 02. Seconds to run the Create Table query.

Figure 48

Before executing the query, the SsisEditor database had only the system tables.

Figure 49

After the query execution, the HR.Departments table was created as shown below.

Figure 50

The table has only a structure at this point.

Figure 51