DTS Package running on SQL Server 2008 R2 64 bit - can't find runtime download
-
Saturday, January 26, 2013 8:48 PM
Current system is running SQL Server 2008 R2 on 64 bit machine. I am trying to edit a DTS package which has been upgraded previously to work on SQL2008 (not migrated to integration services, this DTS package has just been imported). I receive the error "Install the special Web download 'SQL Server 2000 DTS Designer Components' to use this feature (Microsoft.SqlServer.DtsObjectsExplorerUI)"
I look online for the web download and it is a dead link. I've checked to see if backwards compatibility is installed on this SQL Server and confirmed that it is installed.
Anyone know a way I can edit this DTS Package?
All Replies
-
Saturday, January 26, 2013 8:56 PMModerator
Please have a look at this post that porvides active links:
http://www.bisql.net/2010/11/how-to-edit-dts-packages-in-sql-server-2008-r2/
David Dye My Blog
- Marked As Answer by CyMario Sunday, January 27, 2013 12:41 AM
-
Sunday, January 27, 2013 12:41 AMAwesome. Thank you very much for your assistance. I wasn't aware that SQL 2005 and SQL 2008 were interchangeable at times.
.png)
