January 18, 2012 at 9:54 am
I was approached by someone who recently set up a Server and there is no DTS node under Legacy on a SQL Server 2005 Machine.
I just installed SQL Server and I did not have that problem.
Simply stated if you expand Management >> Legacy there is no Data Transformation Services Node.:unsure:
What causes this?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2012 at 10:03 am
I just found out that he is connecting to an Database Server instance from a Web Server using SQL Server 2005 Express.
He stated that he installed SQLServer2005_DTS.msi and SQLServer2005_BC.msi on both the Web and Database Server. He stated that he got an error on the x64 Bit DB Server.
The Web Server is x32 Bit.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply