Sunday, February 26, 2012

DTS not able to open

Hi experts,
i have faced one issue with DTS, my office SQL server is 2000 x86
version, but my labtop using SQL Server managment studio, when i try
to expend the office SQL DTS package, which show me "this package
cannot be edited" and the following msg is "SQL server 2005 DTS
Designer components are required to edit DTS packages", "Install the
special Web download, SQL Server 2000 DTS designer components to use
this feature". however my co-worker are able to open, this is
something special , and my SQL studio setting almost same as him.
my labtop detail:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
pls advise, many thanksHi
Check out the information on
http://technet.microsoft.com/en-us/...y/ms143706.aspx for more
information. If you need to edit a DTS package you will need to download the
Microsoft SQL Server 2000 DTS Designer Components from the features pack
http://www.microsoft.com/downloads/.../>
a42ec403d17
John
"XJ" wrote:

> Hi experts,
> i have faced one issue with DTS, my office SQL server is 2000 x86
> version, but my labtop using SQL Server managment studio, when i try
> to expend the office SQL DTS package, which show me "this package
> cannot be edited" and the following msg is "SQL server 2005 DTS
> Designer components are required to edit DTS packages", "Install the
> special Web download, SQL Server 2000 DTS designer components to use
> this feature". however my co-worker are able to open, this is
> something special , and my SQL studio setting almost same as him.
> my labtop detail:
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.1.2600
>
> pls advise, many thanks
>

No comments:

Post a Comment