Is this resolved?

MJ

Is this resolved?

Mj

Try scheduling a agent job which capture ping server results to a table and see if it has any time out entries when the connection timeouts an application side.

MJ

I can easily copy defaults property by making use of copy sql server objects task in dts.

http://msdn.microsoft.com/en-us/library/aa933510(SQL.80).aspx

MJ

DO you really want to make use of encryption? If not then recreate your endpoints with encryption=DISABLED.

MJ

Is it resolved? Whats the data type of the source column tht is causing problem in excel?

MJ

Thanks for sharing the solution.

Manu

Is this resolved?

MJ

Try using sp_dbremove for that database.

http://msdn.microsoft.com/en-us/library/ms187980.aspx

MJ

I think reconfiguring is an way out here.

MJ

Then you dont need that second log file for this database.

MJ

Try running profiler with filter in textdata for this table.

MJ

Use xp_cmdshell for running the followng command:

DTSRun /S "server name" /N "dts name" /W "0" /E

MJ

Is clustered index defined on the table in question?

MJ

See what message you receive when you try to run it under management studio...

MJ