Execute SQL Error In SSIS

I've got a sql script that I wish to automate. It's really simple and works great in Management Studio. I thought I could simply create an SSIS Integration Services project, place the code in an "Execute SQL Task" object and go, but I'm running into problems. Here's the code:

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
use polk_vector
go

drop table gisadmin.TMS_Numbers_Not_Found_Tax_Database
go

select distinct TMS as 'Not found in Tax Database'
into gisadmin.TMS_Numbers_Not_Found_Tax_Database
from gisadmin.parcel_polygons
where not exists
(select *
from gisadmin.final_tax_data
where gisadmin.parcel_polygons.tms = gisadmin.final_tax_data.akpar#)
go
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I created a connection to the SQL database, then inserted the above code into the "Execute SQL Task" object. The query parsed correctly, but when I tried to "build" the query, it gave me the following error: "The USE polk_vector SQL construct or statement is not supported."

So I removed the 1st two lines and tried again. This time, I got this error: "The DROP TABLE SQL construct or statement is not supported."

Can anyone give me some guidance? I assumed I could simply stick the functioning query in and go, but there's obviously more going on than I realize.

Any advise will be much appreciated.

Thanks.

Kent Rothrock
Highland Mapping, Inc.
kentrothrock@hotmail.com