I have found that if you Create the table with primary key.

CREATE TABLE tbl_Example (

[Field1] [int] Not Null Primary Key,

[Field1] [Char] Null)

on [Primary]

Go

there will be no object in sysobjects called...

Your ZIPCODE Field is a Varchar and therefore will probably be sorted in Alpha order not numerical order.  For example (1,2,3,10,12,20) would sort (1,10,12,2,20,3).

You can partition the table and then create view that presents it to the application as one object.  You can even name it the same as the 'old' table and...

Remember that the transaction log is capturing all the changes made to the data before it is committed to the database.  This provides the up to the level of recoverability...

Does this generate the same information as the output text file from the job step that is running the package?

Can you put them in a custom role and explicitly deny them access to the database?

Or Better yet, remove the group from the server all together. 

I am not sure but...

So is TRUNCATE TABLE considered DDL as well?

Truncate table has the same permissions as DROP TABLE.  The package is to be executed by a user that has minimal permission in the database, not a sysadmin, db_owner or...

The real problem that I am seeing is the the server runs at 100 percent CPU utilization for hours.  Causing timeouts etc.

I like where you are going with this. I work in a small MIS shop supporting a collections center for a large bank. We started using SQL server...