September 30, 2010 at 1:02 pm
Hi, I was wondering if anyone out there has had any experience and success setting up the sql DTS backward compatiblity components using widows 7. I had this working on my desktop fine with XP but I had to get a new desktop computer that has Windows 7 installed and had to reinstall sql server 2008. I've tried several times to install th BC components and either management studio will close out with and error when I try to open a DTS packeage or it wont recognize the installed BC components and it still asks me to install the BC apps. I tried using the "troubleshoot compatibility" option in windows 7 and it did not seem to make a difference. Microsoft does not list Win 7 as a supported OS with the BC download. Has anyone succesfully installed this with windows 7 and sql 2008?
Thanks
Mickle
September 30, 2010 at 1:15 pm
I also tried the same but facing same type of issue. One of my machine has Win XP with SQL 2008 R2 - DTS designer is working fine in that but in other machine which has Win 7 - DTS is not working.
As per the BOL:
Limited DTS Functionality on 64-bit Operating Systems
SQL Server 2008 does not include support for DTS in the following circumstances:
* There is no 64-bit design-time or run-time support for DTS packages. On a 64-bit computer, DTS packages, and Integration Services packages that run DTS packages, can run only in 32-bit mode. For more information, see How to: Install Support for Data Transformation Services Packages.
* There is also no 32-bit design-time or run-time support for DTS packages on Itanium-based operating systems. Therefore, you cannot create, view, modify, or run DTS packages on Itanium-based operating systems.
Thanks
October 1, 2010 at 2:08 pm
That was my inclination from what I have read but I was hoping there was some fix or workaround. Thanks for the response.
Mickle
January 18, 2011 at 7:36 am
What about when running Windows 7 on 32 bit? I am having problems with it in 32 bit as well. I am getting the same error after installing the BC components.
October 4, 2011 at 7:18 am
Mickle (9/30/2010)
Hi, I was wondering if anyone out there has had any experience and success setting up the sql DTS backward compatiblity components using widows 7. I had this working on my desktop fine with XP but I had to get a new desktop computer that has Windows 7 installed and had to reinstall sql server 2008. I've tried several times to install th BC components and either management studio will close out with and error when I try to open a DTS packeage or it wont recognize the installed BC components and it still asks me to install the BC apps. I tried using the "troubleshoot compatibility" option in windows 7 and it did not seem to make a difference. Microsoft does not list Win 7 as a supported OS with the BC download. Has anyone succesfully installed this with windows 7 and sql 2008?Thanks
Mickle
Is there a fix for this? I am having the same issue...
April 20, 2012 at 12:01 pm
I am having this issue on a win7 x86 non-itanium system. Has anyone had any luck with Compatibility mode installations?
April 20, 2012 at 12:29 pm
I found this post that helped fix my issue:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/bcae9086-4345-4c59-8dd8-9ddeca4edc45/[/url]
IT basically says to update the Path System Variable so it finds the BC elements before it finds the new stuff:
After changing the order in the path setting it got resolved.
For 32 bit installations:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; should appear before the
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
Incase of 64 bit machine:
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;
Be sure to restart the SSMS after changing the PATH env variable.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply