Open DTS package in SQL 2008

• montril2121

  SSC Enthusiast

  Points: 186

  More actions

  August 17, 2010 at 6:32 am

  #225959

  Hi,

  I am unable to open DTS package in SQL 2008 (64 bit) in Windows 2008 (64 bit). DTS 2000 components, 2005 backward compatibility and SQL 2000 client tools are installed but nothing work.

  Even after installing above components, it shows "SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)"

  Can you help me in this issue?

• VRR

  Ten Centuries

  Points: 1170

  More actions

  August 18, 2010 at 2:57 pm

  #1208791

  DTS is not supported in 64 bit. Check the below link to open the DTS in 32 bit mode

  http://msdn.microsoft.com/en-us/library/bb500440.aspx