DTSX files - How to peruse & edit

Question

I have a DTSX file in a project I'm taking over. I have Visual Studio 2005 Pro, but it just opens it as an XML file. SQL Server Management Studio 2005 does the same.

I've seen people opening these files in some workflow-esque format; Business Intelligence Development Studio comes to mind.

Is this part of Visual Studio or SQL? Does it have to be purchased seperately? Can I open this file in a more useful way with the tools I have?

Answer 1

Hi

You need the Business Intelligence Studio ..I've justed checked and my version of VS2008 Pro doesn't have them installed.

try:

http://www.microsoft.com/downloads/details.aspx?familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q%5F23183245.html

Cheers