I read in Kirk Haselden's book "Microsoft SQL Server 2005 Integration Services" that if SQL Serfver 2005 and 2000 are installed on the same machine as seperate instances then you can view the SQL Server 2000 DTS packages in 2005 Management Studio under the Management tree, Legacy, Data Transformation Services node.
But in my case, I am not able to see DTS packages in Management Studio. Is there a property or a setting that we need to configure for that?
Thanks.
Can you find the node for Data Transformation Services? If so, why can you not see anything, or perhaps what do you see? Have you got any DTS packages on that server, to show in SSMS?
|||Yes, I can see the node for Data Transformation Services but nothing underneath it, even when I refresh it.
No comments:
Post a Comment