I don't think you can compress text data while copying using sql server native functions/tools...

Defintely there are third party tools out there but I don't remember at this time...

Did you add the precidence between three tasks?

How to import XML into SQL Server with the XML Bulk Load component

http://support.microsoft.com/kb/316005

Check the following thread... it may resolve your issue too...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=255347&SiteID=1

I think your sql server is using windows authentication only...

I think you need to change to mixed authentication..

Windows Authentication mode is the default security mode after a typical installation of...

Are you sure you will be getting the right data... because you were looking to send the data from deleted table where as if you use customername .. may be...

Are you migrating sql 2000 to 2000? or 2000 to 2005?

After restoring all user database or after attaching all user databases migrate the login using the script from the following...

Insert into temp table and the use  temp table in send mail...

you may query the data from the table which as corruption...it is hard find anything...

Some times you know the table/index has corruption but you can query the data....you get the...

Right click dts packages/new packages...

create a connection to excel file...and SQL server where you want to dump the data from excel...

Make three transformations

excel-sheet1------SQL.TABLE1

excel-sheet2------SQL.TABLE1

excel-sheet3------SQL.TABLE1

Use the "-SkipErrors" parameter in Distribution Agent cautiously

http://support.microsoft.com/kb/327817

Another solution for this will be cleanup table in MSDB.

When you enable a table to paricipate in replication, the replinfo column in sysobjects is set to a non-zero number.  When you attempt to drop a table, SQL Server first...

In backup or restore you can't do this...

You can restore same as production with 50 gb file then...create new filegroups in the restored database and move the tables to new filegroups...

When you run the DBCC CHECKDB or DBCC CHECKTABLE, you will the output if there is any corruption...