Are there any error messages in the Exectuion Results?

you say that you are getting an Error, however the log entry you posted is a Warning and should not stop the data from loading.

is your package loading...

not really.

you could restore a backup from prior to 1st Jan 2009 (if you have one) to another db and use this as the basis for comparisons to...

without a field holding this information, you can't get it sorry.

I think that you would be better off comparing the execution plans for the worst performing queries between the two servers and start from there.

I find the easiest way is to create a ssis job to do the processing and then call this job from a stored proc.

it depends on what is an acceptable down-time for your business.

If they require near instance recovery then I would go for Mirroring / Clustering.

tables do not have an order, so the order you insert the data does not really matter. you may luck out every now and again and retain the order...

If it is a linked server then you should be able to use the Four part naming convention

select * from [server] . [database] . [schema] . [object]

sorry, i just...

I would have thought that if the check constraint is checking for the same max length as the data type length then it is kind of pointless..

if you reseed to 0 then the id value will be 0 , what do you want the Id value to be?

also what are you trying to do with...

how did you write it if you don't know what it does?

it looks like it is creating an instance of wshell

it will be under programs -- > under sql 2005 --> configuration tools

open sql server configuration manager.

select sql server services.

ensure SQL server is running.

if you have instances then you will need to start sql browser (most likely you don't though)

then check...

have you enabled remote connections? (from memory this defaults to off for express)

and started SQL browser ?