Is there any index on your table? If so, you may try to drop the indexes before addding data. After completing your update of data, re-create indexes.

Where is your distribution database located? You may have to check the security in your replication.

The easiest way is to rebuild your replication sometimes.

We can use BIT MASK concept to implement this task.

For example:

Column123456

Bit Mask12481632

To test whether or not columns 4 or 6 are updated,...

What kind of mis-match? Make sure data types are also matched.

After viewing your attached file, I guess there might be more than one issue in your system.

Couple suggestions:

1. Check your anti-virus software, and see whether or not the data folders...

DBCC SQLPERF(LOGSPACE)

xp_fixeddrive

Yes, they are log shipping related. Log shipping backup transactional logs on the source server, ship them to the target server, then, restore logs there.

I would like to recommend you to add a log file to your DTS package in order to find errors in detail.

It should be in registry.

Try to use UDL to build your connection string. Here is the link.http://msdn2.microsoft.com/en-us/library/aa140076.aspx

If my guess is correct, you have a RAID 5. You would like to partition this array into 4 logical drives.

If so, there is no help in enhancing performance.

I confirm it. I can use either Windows authentication or SQL authentication in connecting database engine. But when trying to connect SSIS, I only have Windows authentication.

If my account and...

In my memory, SQL 2005 does not log detail in the indexing, but the command.

The problem is that the indexing takes space in its process. Since existing indexes take space,...

Could you use IMPORT/EXPORT to migrate your data to Sybase? You need to have Sybase ODBC driver on your database server.

Here is an example of what SQL Server will do when I tried to change the data type of c2 from INT to BIGINT. Basically, SQL Server replicates the table...