What are the issues that you are having with the import/export wizard?

If you have a relational databae then you need to have FK constraints, without them you may as well look at column database.

The FK can impact perfromance, however they...

I have seen this done before for security and performance reasons.

The speed difference could be down to network speeds what sort of network are they on?

Also a...

Does the data show up as negatives in Excel?

You might find that using a staging table actually improves the performance of the package since SQL server is more efficent at joining/concatenating large sets of data

I would ring them as soon as possible then, as it will probably be the monthly fee that they deducted. I had a similar problem and found them very...

You need to call them to cancel your subsciption, and to ensure that they are not charging you, their number is on the customer service portal...

I would opt for using 3 files as suggested, but if this not possible then you could put the results of your current package into a single staging...

You wont be able to drop the table whn there is a foreign key referncing it, you need to drop the reference or the referencing table first

you wont be able to shrink it if there are open transactions.

how much free space is in the database file?

Have a look at the link posted above, statistics are critical for the query optimizer to work effectively.

Also i would take any advice from the Database Tuning Advisor ...

It depends on a number of things,

-your statistics could be different on the machines,

- there could be other things running.

- you may not have been clearing the...

You may have to do some debugging on the package to see why it is failing , put in a breakpoint on on the IF statement in script...

it looks like you dont have the correct permissions for the linked server.

Have a look at the linked server logs to see why the login failed.