This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package uses an application is using the SqlClient provider...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
10-01-2007
Filed under: sql server, performance, ssis, trace, update, error, kba, installation, instances, 4014, netmon
Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to updates and delets on the table and the golden rule...
Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight to investigate, similarly how about having such...
Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are under execution. Well the reason is obvious that...