Browse by Tags

Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)
11 February 09 02:15 PM | ssqa.net | with no comments

The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...

Filed under: sql server, 2008, 2005, best practices, integration services, dts, ssis package, 2000, backward compatibility

SQL Server Upgrade - don't forget the Collation issues?
29 May 08 09:08 AM | ssqa.net | with no comments

Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation...

Filed under: sql server, 2005, setup, collation, 2000, upgrade, settings, reference

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
08 April 08 06:04 AM | ssqa.net | with no comments

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

Filed under: sql server, 2005, microsoft, product, mainstream, support, extended, 2000, lifecycle