I agree, that would be your best plan.

Ok, I looked around and cannot find anything on this except unable to do the first query.

What I would do is open Profiler and attach to the remote server. Then...

What service pack are you running and what version (standard, enterprise, msde) of SQL? Do you get any specific error messages and have you checked event viewer? I don't recall...

BCP is another option, but I personally create databases in break downs. For instance we collect call data from an Aspect call center switch which we keep 2 years live...

This is what I have done in the past. The DB files are on E:\ whatever. I rename the folder they are in and move folder to root of E:\.

Reinstall...

I don't think there is a way to have it default. SA would have to create the database for it to default as dbo.

I remember this from a prvious thread. The problem was the process outputing the file put a carriage return on the last row so DTS saw that as an extra...

I may have read something wrong, however going back to your first solution, after pressing the button did you open QA or EM and check to see if you can...

I don't remember but I am pretty sure the answer is no. However you can rename a database by using

sp_renamedb [ @dbname = ] 'old_name' ,

...

SOemtimes it is the ODBC driver causing these errors for various reason and may need to be done in the SQL string of the openquery using the remote datasources syntax....

It might, especially if the package was built in SQL 7 with less than SP3 I believe installed and the other user was using SQL 2000 EM with less than...

Then enigne won't but a quick reinstall and moving the DBs back into proper position should be all you need. The registry has every detail needed to make the SQL...

Can you post examples of the query that executed fine and the one that failed. I have had no issues right off but something may jump out if I can...

That will be nice. Another thought I had based on another thread is if you are using SQL 2000 you can create a table to store BINARY_CHECKSUM values for each...

Have you change anything recently that would be referenced in the package? Maybe you create a connection to the server on one machine when package saved but are now opening...