I set each expression to it's appropriate Execute SQL Task, I assigned no other expressions.

Both of the properties are set to ForceExecutionValue. It didn't co-align with MSDNs definitions per

http://msdn.microsoft.com/en-us/library/ms137749.aspx

-but it was one of the few that actually allowed me to debug still.

Attachment 1 displays the way everything is setup

Attachment 2 displays the first Execution SQL Task(build table)

Attachment 3 displays the second Execution SQL Task (truncate)

I understand that Field1, and Field2 wont be written into my actual table, but I need to create some type of relation when creating a table so I figured I would just keep it.

-This is failing on the build table.

Thanks