I've to agree to post by Jason Selburg. As I've not come across these situation and was trying to fetch information but finally ended up unsuccessfully.

I agree with Sugeesh on this issue.

http://msdn2.microsoft.com/en-us/library/aa258255(SQL.80).aspx --- try this link. Might be useful for your problem

In the SQL Server 2005, after you create a SSIS package ( DTS), you want to create a job and schedule to run it. You will get the error to...

Pleaze find link, on Tracing & how to configure performance on tracing stuff///etc., Hope this will find somehow useful to you in adopting these terminologies....

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

go to entrprs mgr, chk for the advtur db is in SUSPECT MODE. If so, then remove the un-wanted files from the server and move to the remote drive where...

I'm not sure the below topic will help you in solving this issue.. Try this!!!!!!!!

http://technet2.microsoft.com/windowsserver/en/library/22764cb5-9860-4f8f-95e7-337df24edf741033.mspx?mfr=true

Try out this examples for NO LOCK when,where & how to use the same....

sqljunkies.com/Forums/Search/default.aspx?SearchFor=1&SearchText=AspiringGeek

channel9.msdn.com/wiki/default.aspx/PerformanceWiki.SQLServer2000Guidelines

msdn2.microsoft.com/en-us/library/ms998577.aspx

classicasp.aspfaq.com/general/how-do-i-make-my-asp-pages-more-efficient.html

http://www.mssqltips.com/tipimages/1253_concurrencyIsolationLockingVersioning.txt

http://www.simple-talk.com/sql/sql-server-2005/partitioned-tables-in-sql-server-2005/

in ssis, use expression and write a function to segregate the datetime into the required format what you need.. Please check for MSDN for samples/solutions.....

check this i think this might be helpful 2 u.

http://blogs.msdn.com/sql_protocols/archive/2006/02/27/unable-to-connect-to-a-sql-server-named-instance-on-a-cluster.aspx

http://www.developerfood.com/re-unable-to-connect-to-sql-express-db-without-using-user-instanc/microsoft-public-sqlserver-connect/52bc9b09-66e8-4088-8da0-d4efc317b201/article.aspx

Jay,

Try this!!!!!!!!

msdn2.microsoft.com/en-us/library/ms188465.aspx

Hey,

Try these links which helps in performance better for data transformation from Xcel to Sql....

http://www.excel-db.net/help/features.htm

msdn2.microsoft.com/library/aa203746(office.11).aspx

http://www.sqlmag.com/Article/ArticleID/38905/sql_server_38905.html

search.techrepublic.com.com/search/Microsoft+Excel.html

http://www.vicman.net/lib/excel-match-data.htm - 39k

I guess your each DTS has to call different endpoint connections for data reteriving. For e.g., osd1 is trying to fetch the values from excel, similiarly others might also try...

I think the design of the DB itself is a big FLAW. Each & every time if you go back & try to create indexes that may cause the reflections...