try

alter database

set trustworthy ON

(has its own pros and cons though)

Do you use a package config file?

Right click on your solution, click properties..

Have you set up the delpoyment utility?

Maybe try setting up a deployment build which creates a...

try playing around with SELECT @@ROWCOUNT

In the instructions:

Click the "All" button, scroll up to Extended Properties, and put in "dbase 5.0". If you don't do this, SSIS will try to read your dBase file as...

In properties on the excel connection manager.

Check the connection string. Make sure IMEX=1 in the extended properties.

i.e

Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

hope that helps

It might be a different type of DBF file

i.e try dBASE III or dBASE IV instead of a dBASE 5.0

hope that helps

Thanks for the help

Was definitely the datatype in the excel source:

Resolved by using CSTR(F2)

Cheers

Are you running a Trial version? Maybe it has expired and wont let you carry on using it...

Hint:

Description: Integration Services evaluation period has expired.

Those are the main two:

TABLOCK is very useful in an online enviroment.

Are there any clustered views? Complex Indexes? Refreshing you statistics will help performance too.

Run a Performance Monitor to...

BULK INSERT gives you a level of control for sizing the amount of data-moving that is difficult to achieve in SQL.

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

Try a BULK INSERT.