Check sqldts.com for this kind of solutions...

check the following link which may help you...

http://www.sqldts.com/218.aspx

I believe you are using xp_sendmail at this time in 2005...

What is @separator  you are using... try using @separator= ','

Please post your code...

If the dts package stored in MSDB, it will be stored in sysdtspackages table but you can't query the Package configuration...because it is stored in hex format in sysdtspackages.packagedata column.

You...

We you create alias they can't communicate with each other...

First check you can access the remote server from Query Analyzer.

Check the following article...

http://www.sql-server-performance.com/pi_replication_across_internet.asp

If initial snapshot completed then how BCP is being executed?

It is true, MS asks us to apply the patch only if you are experiencing the specific issue..

But sometimes MS releases Cumulative hotfix package...and recomend us to apply...

Are you able ping both server from one to another?

Why are you creating alias? You mean linked server?

Are you able to connect remote server with QA?

Script the objects using SSMS and compare them manually if you don't have any coparison tool..

Did you initialize the snapshot?

Yes, snapshot isolation level supports in all editions...

Features Supported by the Editions of SQL Server 2005 

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step

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

I believe you are out of luck in that case....

or

Check for third party tools if you guys want to spend money...

If you don't have the log space ....you can change Insert batch size in the dts package properties... but it will take longer than normal to complete the process.

xp_SMTPmail mail is to replace sql mail not sql agent mail.

System and Storage Configuration for SQL Server

http://www.sql-server-performance.com/jc_system_storage_configuration.asp

If you check the "Attempt to repair any minor problems" option, sql server will try to change the db to single user mode to run the repairs...

It is not...