When you did the Export did you select "copy objects and data beween SQL Sever databases" then make sure that the "copy all objects is selected" This option should include...

Try removeing the DTSExecuteSQLTask_1. the other two workflow propertites should look like the following.

dts task_dtsExecuteSQLTask_2

Source step = "drop table"

Precedence = "success"

Destination Step = "Create Table"

dts task_dtsdatapump task_1

Source step = "Create...

What does your workflow properties look like? They should be as a success on the task you want to be completed prior to that step executing.

Hope that helps