[MS SQL Server] working with sql server 2008 R2 |
- working with sql server 2008 R2
- Migrating DTS Packages from SQL 2000 to 2008
- Unable to open DTS packages
| working with sql server 2008 R2 Posted: 19 Apr 2013 12:09 AM PDT I want to know the exact difference between sql 2008 and sql 2008 R2.Which is preferable and when to use R2 version.I already have Sql 2008 installed enterprise edition how install R2 edition? |
| Migrating DTS Packages from SQL 2000 to 2008 Posted: 27 May 2010 07:14 AM PDT Hi All,I am looking to migrate the SQL 2000 applications to SQL Server 2008and the OS will be Windows 2003 Server.the server where we run a lot of DTS's. I understand that SQL 2008requires some add-ons to be downloaded and installed to make DTS'swork.Can you please let me know which type of add-ons I need to download it? and where can I get that?Thanks in advance,Vamsi. |
| Posted: 26 Sep 2011 06:51 PM PDT Hi Folks,I have a sql server 2000 instance.i migrated my databases and DTS packages to SQL server 2008 R2.Am unable to open the DTS packages which i migrated from SQL SERVER 2000 to SQL SERVER 2008 R2.i've installed SQL server 2000 DTS Designer components and SQL server 2005 Backward compatability Softwares which was suggested by Microsoft and then copied the .dll and .rll files suggested by microsoft and then changed the path in Environment Variables.After doing all these things as well am getting the same error while opening DTS pkg. in SQL SERVER 2008 R2error is :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.DtsObjectExploreUI).Please Help me...TIA... |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment