I am trying to install DTS designer 2000 ,if anyone knows place or link from where I can download please let me know.I have vista OS in laptop ,is it compatible with vista .It's urgent please let me know.

Hi Mike. Check this URL for the full description of how to download and install it: http://msdn.microsoft.com/en-us/library/aa544774%28v=cs.70%29.aspx And yes, DTS designer 2000 is compatible with Vista.http://thebipalace.wordpress.com/

Go here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en Get the two files SQLServer2005_BC.msi and SQLServer2005_DTS.msi. Install both. One is for Design time support and one is for Run-time support. Then after you have done all that, think about migrating your DTS packages over to SSIS. It is SUCH a better tool!Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.