Anyone know of any good AS performance tuning guides on the web?

Anyone know of any good AS performance tuning guides on the web?
AS Performance Guide
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
Unfortunately the link is broken right now. I am have one of the web guys on
our side see what might have happened.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ian W" <IanW@.discussions.microsoft.com> wrote in message
news:08DAB627-0868-484E-831C-B19E90FE320A@.microsoft.com...
> Anyone know of any good AS performance tuning guides on the web?
|||Hello Dave and Ian,
Check out http://www.sql-server-performance.com/articles_bi.asp
There are a few articles to get you started until the link is fixed.
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/

Anyone know of any good AS performance tuning guides on the web?

Anyone know of any good AS performance tuning guides on the web?AS Performance Guide
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
Unfortunately the link is broken right now. I am have one of the web guys on
our side see what might have happened.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ian W" <IanW@.discussions.microsoft.com> wrote in message
news:08DAB627-0868-484E-831C-B19E90FE320A@.microsoft.com...
> Anyone know of any good AS performance tuning guides on the web?|||Hello Dave and Ian,
Check out http://www.sql-server-performance.com/articles_bi.asp
There are a few articles to get you started until the link is fixed.
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/sql

anynone seen this error

Hello,
Does anyone seen this error before?
I've searched through the web, books online, and googles groups. NOTHING.
Event ID 17052, Category 2
Error 50501, severity 16
State 1
DBE_add_event: Invalid taskbinder (taskbinder id=0, rows=0)
This event occurs very often, like each 4-5 minutes....
ThanksIs this error from SQL Server as source? If so, then it is a user-defined error (as it has > 50000
as error number). I suggest you check this with your application vendor.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dany" <dany_langlois@.yahoo.com> wrote in message
news:4080a045.0312160725.2f6df8db@.posting.google.com...
> Hello,
> Does anyone seen this error before?
> I've searched through the web, books online, and googles groups. NOTHING.
>
> Event ID 17052, Category 2
> Error 50501, severity 16
> State 1
> DBE_add_event: Invalid taskbinder (taskbinder id=0, rows=0)
>
> This event occurs very often, like each 4-5 minutes....
> Thankssql

Any whitepaper that talks on Web Servers to SQL server connections

I can understand when theres SQL authentication involved and how one may
pass the SQL Server credentials that way ..
But cant figure out how would IIS connect using Windows Authentication ?
What Windows login would these web servers need ? Do i create that same
login on all Web Servers and also on SQL .. What this anonymous login ? We
want to tighten the controls using Windows Authentication and dont know how
to do so with Web Servers..
Authentication and Security White Paper for Internet Developers
http://support.microsoft.com/default...b;en-us;174811
Understanding Internet Information Security
http://www.microsoft.com/ntserver/te.../iissecure.asp
AMB
"Hassan" wrote:

> I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know how
> to do so with Web Servers..
>
>
|||This paper discusses the ASP.NET model. Basically it looks like you have to
grant the ASPNET user database and some other permissions. Hope this helps:
http://msdn.microsoft.com/library/de...SecNetch08.asp
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OneQ%23N3RFHA.3732@.tk2msftngp13.phx.gbl...
>I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know
> how
> to do so with Web Servers..
>

Any whitepaper that talks on Web Servers to SQL server connections

I can understand when theres SQL authentication involved and how one may
pass the SQL Server credentials that way ..
But cant figure out how would IIS connect using Windows Authentication ?
What Windows login would these web servers need ? Do i create that same
login on all Web Servers and also on SQL .. What this anonymous login ? We
want to tighten the controls using Windows Authentication and dont know how
to do so with Web Servers..Authentication and Security White Paper for Internet Developers
http://support.microsoft.com/default.aspx?scid=kb;en-us;174811
Understanding Internet Information Security
http://www.microsoft.com/ntserver/techresources/webserv/iissecure.asp
AMB
"Hassan" wrote:
> I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know how
> to do so with Web Servers..
>
>|||This paper discusses the ASP.NET model. Basically it looks like you have to
grant the ASPNET user database and some other permissions. Hope this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch08.asp
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OneQ%23N3RFHA.3732@.tk2msftngp13.phx.gbl...
>I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know
> how
> to do so with Web Servers..
>

Any whitepaper that talks on Web Servers to SQL server connections

I can understand when theres SQL authentication involved and how one may
pass the SQL Server credentials that way ..
But cant figure out how would IIS connect using Windows Authentication ?
What Windows login would these web servers need ? Do i create that same
login on all Web Servers and also on SQL .. What this anonymous login ? We
want to tighten the controls using Windows Authentication and dont know how
to do so with Web Servers..Authentication and Security White Paper for Internet Developers
http://support.microsoft.com/defaul...kb;en-us;174811
Understanding Internet Information Security
http://www.microsoft.com/ntserver/t...v/iissecure.asp
AMB
"Hassan" wrote:

> I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know ho
w
> to do so with Web Servers..
>
>|||This paper discusses the ASP.NET model. Basically it looks like you have to
grant the ASPNET user database and some other permissions. Hope this helps:
Netch08.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
Netch08.asp
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OneQ%23N3RFHA.3732@.tk2msftngp13.phx.gbl...
>I can understand when theres SQL authentication involved and how one may
> pass the SQL Server credentials that way ..
> But cant figure out how would IIS connect using Windows Authentication ?
> What Windows login would these web servers need ? Do i create that same
> login on all Web Servers and also on SQL .. What this anonymous login ? We
> want to tighten the controls using Windows Authentication and dont know
> how
> to do so with Web Servers..
>

Any tutorials (confused!)

Hi,
I'm new to this reporting services technology, but done a far bit of C#
and web services. In the current system I work on we have a complex
typed dataset which I want to use as the source for a reporting
services report.
using c#, can you let me know if the following is possible and point me
in a direction;
Populate the typed dataset in the main c# application.
Call reporting services, passing in this dataset (or XML) as a
parameter
All I've done with reporting services so far is to create a static
report and render this as a PDF and output the result to a physical
file on the local hard drive.
Many thanks
MatMat, have a look at www.gotreportviewer.com
HTH,
Ed
<matpublic@.ntlworld.com> wrote in message
news:1140550512.461086.100440@.g44g2000cwa.googlegroups.com...
> Hi,
> I'm new to this reporting services technology, but done a far bit of C#
> and web services. In the current system I work on we have a complex
> typed dataset which I want to use as the source for a reporting
> services report.
> using c#, can you let me know if the following is possible and point me
> in a direction;
> Populate the typed dataset in the main c# application.
> Call reporting services, passing in this dataset (or XML) as a
> parameter
> All I've done with reporting services so far is to create a static
> report and render this as a PDF and output the result to a physical
> file on the local hard drive.
> Many thanks
> Mat
>

Any news on different browsers?

I'm using the ReportViewer web control and RS 2005 and notice that
reports don't come close to rendering correctly in FireFox.
I had read posts concerning RS2000 and was thinking that maybe the new
release would be compatible with browsers other than IE.
Does anybody know of (1) any techniques to make the viewer work; or
(2) any news about
an upcoming release that would work?
Also, out of curiosity, has anybody tried this Report Viewer with IE7?
JimWe just upgraded to Reporting Services 2005 and I'm noticing the same thing:
serious rendering problems with reports in Firefox. Specifically:
1. Rendering sometimes ignores hard width values (in inches).
2. Some columns nearly disappear, data in them is not visible.
3. Report height is much less than specified (again, in inches).
I could live with work-arounds, but the fact that no one has even replied to
two separate queries on this subject makes me wonder if there are any.
On a more positive note, the toolbar now works in Firefox!
--
Software Engineer
Educational & Community Supports
University of Oregon
Eugene, OR 97403-1235
"jhcorey@.yahoo.com" wrote:
> I'm using the ReportViewer web control and RS 2005 and notice that
> reports don't come close to rendering correctly in FireFox.
> I had read posts concerning RS2000 and was thinking that maybe the new
> release would be compatible with browsers other than IE.
> Does anybody know of (1) any techniques to make the viewer work; or
> (2) any news about
> an upcoming release that would work?
> Also, out of curiosity, has anybody tried this Report Viewer with IE7?
> Jim
>

Any easy way to create SQL on the fly with RS?

I am very new to reporting services. I am using reporting services
with Visual Web Developer and my database is Oracle 10g.
I have successfully created reports using the MS reporting services.
Data were pulled out from Oracle 10g through pre-defined SQL.
I would like to display on the web a list of fields that my end users
can select, and then my web application creates the SQL command on the
fly according to end users' selection criteria. Any easy way to do
this with the reporting services?
I hope that I have made clear what effect I would like to achieve. If
not, please ask. Thanks.If you are using SSRS 2005 then you got the answer. Just have a look at what
is called "Report Model" where in you can create a view where you can give
the readable column names and the users can drag and drop to get the reports.
Amarnath
"antonyliu2002@.yahoo.com" wrote:
> I am very new to reporting services. I am using reporting services
> with Visual Web Developer and my database is Oracle 10g.
> I have successfully created reports using the MS reporting services.
> Data were pulled out from Oracle 10g through pre-defined SQL.
> I would like to display on the web a list of fields that my end users
> can select, and then my web application creates the SQL command on the
> fly according to end users' selection criteria. Any easy way to do
> this with the reporting services?
> I hope that I have made clear what effect I would like to achieve. If
> not, please ask. Thanks.
>|||Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
> "antonyliu2002@.yahoo.com" wrote:
> > I am very new to reporting services. I am using reporting services
> > with Visual Web Developer and my database is Oracle 10g.
> >
> > I have successfully created reports using the MS reporting services.
> > Data were pulled out from Oracle 10g through pre-defined SQL.
> >
> > I would like to display on the web a list of fields that my end users
> > can select, and then my web application creates the SQL command on the
> > fly according to end users' selection criteria. Any easy way to do
> > this with the reporting services?
> >
> > I hope that I have made clear what effect I would like to achieve. If
> > not, please ask. Thanks.
> >
That sounds great. I am not sure which version I am using, but I just
downloaded it a few weeks ago from Microsoft as a plug-in for Visual
Web Developer. I'll check it out.|||> Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
>
Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
2005. I was not able to see anything called "Report Model" in VWD.
As I mentioned before, I've successfully created reports using this
Add-in. But the reports I created were predefined. I would like to
let my web users select what data they would like to get from the
database, and then create the SQL on the fly. I hope that I can do
this with this Reporting Add-in.
Any idea about how I can do this? Thanks.|||antonyliu2002@.yahoo.com wrote:
> > Amarnath wrote:
> > If you are using SSRS 2005 then you got the answer. Just have a look at what
> > is called "Report Model" where in you can create a view where you can give
> > the readable column names and the users can drag and drop to get the reports.
> >
> > Amarnath
> >
> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
> 2005. I was not able to see anything called "Report Model" in VWD.
> As I mentioned before, I've successfully created reports using this
> Add-in. But the reports I created were predefined. I would like to
> let my web users select what data they would like to get from the
> database, and then create the SQL on the fly. I hope that I can do
> this with this Reporting Add-in.
> Any idea about how I can do this? Thanks.
I've googled a little bit, and the tutorials I found on creating
reporting models all use BI Development Studio. Does this mean that I
cannot possibly create a reporting model with the Add-in in Visual Web
Developer 2005?|||The BI tools come with their own version of VS. If you have it, it
integrates with it. If not, then it installs it. This means that VS 2005
does not need to be purchased.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161640436.894263.5660@.i3g2000cwc.googlegroups.com...
> antonyliu2002@.yahoo.com wrote:
>> > Amarnath wrote:
>> > If you are using SSRS 2005 then you got the answer. Just have a look at
>> > what
>> > is called "Report Model" where in you can create a view where you can
>> > give
>> > the readable column names and the users can drag and drop to get the
>> > reports.
>> >
>> > Amarnath
>> >
>> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
>> 2005. I was not able to see anything called "Report Model" in VWD.
>> As I mentioned before, I've successfully created reports using this
>> Add-in. But the reports I created were predefined. I would like to
>> let my web users select what data they would like to get from the
>> database, and then create the SQL on the fly. I hope that I can do
>> this with this Reporting Add-in.
>> Any idea about how I can do this? Thanks.
> I've googled a little bit, and the tutorials I found on creating
> reporting models all use BI Development Studio. Does this mean that I
> cannot possibly create a reporting model with the Add-in in Visual Web
> Developer 2005?
>|||> Bruce L-C [MVP] wrote:
> The BI tools come with their own version of VS. If you have it, it
> integrates with it. If not, then it installs it. This means that VS 2005
> does not need to be purchased.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
Thanks, Bruce, are you suggesting that the BI Development Studio is
free? Where can I get it?
I have no Visual Studio 2005, what I have is the free Visual Web
Developer 2005.|||It is free. It comes on the SQL Server media.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161658217.724868.128170@.b28g2000cwb.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> The BI tools come with their own version of VS. If you have it, it
>> integrates with it. If not, then it installs it. This means that VS 2005
>> does not need to be purchased.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
> Thanks, Bruce, are you suggesting that the BI Development Studio is
> free? Where can I get it?
> I have no Visual Studio 2005, what I have is the free Visual Web
> Developer 2005.
>|||> Bruce L-C [MVP] wrote:
> It is free. It comes on the SQL Server media.
>
Thanks, Bruce.
Before I proceed, I have a question. We don't use MS SQL Server as our
database behind our web application. Instead, we use Oracle 10g. Will
I be able to create a web-based application that allows users to create
ad-hoc reports using the SQL Server reporting services and Oracle 10g?
Thanks.|||Developers yes, end users no.
Report Designer is for developers and that works against Oracle. For end
users there is a another tool where first a developer/dba creates a model
and that model is used by the end users to create their own reports. Models
can not be created against Oracle data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161703326.930679.107880@.i3g2000cwc.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> It is free. It comes on the SQL Server media.
> Thanks, Bruce.
> Before I proceed, I have a question. We don't use MS SQL Server as our
> database behind our web application. Instead, we use Oracle 10g. Will
> I be able to create a web-based application that allows users to create
> ad-hoc reports using the SQL Server reporting services and Oracle 10g?
> Thanks.
>|||> Bruce L-C [MVP] wrote:
> Developers yes, end users no.
> Report Designer is for developers and that works against Oracle. For end
> users there is a another tool where first a developer/dba creates a model
> and that model is used by the end users to create their own reports. Models
> can not be created against Oracle data.
>
Thanks, Bruce.
I am new to Reporting Services. The kind of reports I've managed to
create with the Reporting Services Add-in in Visual Web Developer are
from predefined SQL queries.
Just for the purpose of simplicity, suppose that in my web application,
I present the names of 10 students in a dropdown list. I would like to
let my web users select one of these students and then I construct the
sql query on the fly, and create a report about this selected student
only.
Is this do-able with the Reporting Services Add-in in Visual Web
Developer 2005 Express Edition?
Thanks.

Any downloadable tool to chart my perfmon data ?

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the
SQL database without writing any code ?
Thanks
Have you looked at SQL Server Reporting Services?
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:uSKfHsfSIHA.2000@.TK2MSFTNGP05.phx.gbl...
>I am collecting perfmon data in a SQL database but I dont know how to write
>any web code,etc. to display the contents in a chart so I can look at the
>data over a specified time range.
> Are there any tools out there that I can download and just point it to the
> SQL database without writing any code ?
> Thanks
|||Hassan wrote:
> I am collecting perfmon data in a SQL database but I dont know how to
> write any web code,etc. to display the contents in a chart so I can look
> at the data over a specified time range.
> Are there any tools out there that I can download and just point it to
> the SQL database without writing any code ?
This may be one of those things that's not as hard as you think. Go
into Excel, connect to your external data source then use the chart wizard.
Hal Rottenberg <hal@.halr9000.com>
Author, TechProsaic (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Co-host, PowerScripting Podcast (http://powerscripting.net)

Any downloadable tool to chart my perfmon data ?

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the
SQL database without writing any code ?
ThanksHave you looked at SQL Server Reporting Services?
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:uSKfHsfSIHA.2000@.TK2MSFTNGP05.phx.gbl...
>I am collecting perfmon data in a SQL database but I dont know how to write
>any web code,etc. to display the contents in a chart so I can look at the
>data over a specified time range.
> Are there any tools out there that I can download and just point it to the
> SQL database without writing any code ?
> Thanks|||Hassan wrote:
> I am collecting perfmon data in a SQL database but I dont know how to
> write any web code,etc. to display the contents in a chart so I can look
> at the data over a specified time range.
> Are there any tools out there that I can download and just point it to
> the SQL database without writing any code ?
This may be one of those things that's not as hard as you think. Go
into Excel, connect to your external data source then use the chart wizard.
Hal Rottenberg <hal@.halr9000.com>
Author, TechProsaic (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Co-host, PowerScripting Podcast (http://powerscripting.net)

Any downloadable tool to chart my perfmon data ?

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the
SQL database without writing any code ?
ThanksHave you looked at SQL Server Reporting Services?
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:uSKfHsfSIHA.2000@.TK2MSFTNGP05.phx.gbl...
>I am collecting perfmon data in a SQL database but I dont know how to write
>any web code,etc. to display the contents in a chart so I can look at the
>data over a specified time range.
> Are there any tools out there that I can download and just point it to the
> SQL database without writing any code ?
> Thanks|||Hassan wrote:
> I am collecting perfmon data in a SQL database but I dont know how to
> write any web code,etc. to display the contents in a chart so I can look
> at the data over a specified time range.
> Are there any tools out there that I can download and just point it to
> the SQL database without writing any code ?
This may be one of those things that's not as hard as you think. Go
into Excel, connect to your external data source then use the chart wizard.
Hal Rottenberg <hal@.halr9000.com>
Author, TechProsaic (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Co-host, PowerScripting Podcast (http://powerscripting.net)

Any compatibility issues between SQL 2005 Express and SQL 2005 Server

Hi All,

The IP company that host my site is installing SQL 2005 soon and I my building a web application with SQL 2005 Express. So the question is has anyone heard of any problems with uploading an 2005 express onto a sql 2005 server? I would like to find out now before I finish all of the work. Don't want to find out later that you can't run a sql 2005 express database on a sql 2005 server.

Thanks for taking the time to read this.

Well it seem no one know the answer so I emailed the author of a book called Beginning SQL Server 2005 Express. He emailed me back

SQL Server 2005 Express uses .mdf and .ldf file formats that are compatible with SQL Server 2005. Therefore, if you can upload the .mdf and .ldf files for your SQL Server Express database, you or your isp should be able to attach the files to their SQL Server 2005 database server.

I hope this reply helps.

Rick Dobson

So yes you should beable to upload 2005 express onto a SQL Server 2005.

Thanks away guys

Have a good day

Freon22

Answer Re: SQL Server 2000 DTS Tools Web Download

Is the Web Download to install SQL Server 2000 DTS tools available yet? If so where?

Thanks

DarrenIf I answer my own question, at least I'll get one right.

SQL 2000 DTS tools are now available as part of the -

Download details: Feature Pack for SQL Server 2005 Nov 2005
(http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

The direct link to the MSI-

http://www.microsoft.com/downloads/info.aspx?na=46&p=16&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f4%2f4%2fd%2f44dbde61-b385-4fc2-a67d-48053b8f9fad%2fSQLServer2005_DTS.msi&oRef=http%3a%2f%2fforums.microsoft.com%2fMSDN%2fShowPost.aspx%3fPostID%3d126513%26SiteID%3d1|||

I have downloaded the dts tools and when I try to edit a dts package on a SQL2000 instance using the new SQL Server Management Studio, I still get the following errors:

Package Error
Error Source : Microsoft Data Transformation Services (DTS) Package
Errir Description : The DTS host failed to load or save the package properly.
<hit ok>
DTS Designer Error
The selected package cannot be opened. The DTS Designer has been closed.
<hit ok>
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.DtsObjectExplorerUI)
<hit ok>
it takes me to the dts designer (it doesn't close it like it says) and all of the icons in the workspace look like a default windows form icon. I can click on each of them to get the properties, transformations, etc. But I dare not save them.

Any idea how to fix this? Or am I not supposed to be able to manage SQL 2000 instances with this tool.

|||I'm experiencing the very same problem. It occurs even if you right-click on Data Transformation Services and select Open package file..., so it's not a server instance issue. Perhaps it requires the latest MDAC and/or SQL Server Native Client to be installed on the accessed server? Feels a bit buggy to me.|||The designer download does require MDAC 2.6 sp2 or newer, but you're likely to have that already.

-Doug
|||Can we install the SQL Native Client on a SQL2000 box? would that make any difference to the Management Studio?
|||You can install SNAC on SQL 2000 machines, after all that is what happens in side by side installations of SQL 2000 and SQL2005, but it is not requrired for DTS.

I can happily edit most 2000 packages (through the web download designer) on a clean SQL 2005 machine, pointing at an existing SQL 2000 instance. Sometimes I get invalid class string errors, since the SQL 2005 machine lacks some custom tasks I used with DTS. I do sometimes get a similar error to you, but haven't got around to seeing which components are used in a good package and a problem package. I suspect there may be a problem task. AS processing tasks gave some problems, but I skipped around it and haven't had time to work it yet.|||

After uninstalling the entire CTP (including the beta .NET framework) and reinstalling SQL 2005 enterprise I also downloaded and installed the S2k DTS designer web pack.

Now I can't create or save DTS packages in SQL 2000 without getting the same error. In SQL 2005 using the legacy designer I get mixed results.
So I created a new and very simple DTS package on a different (and clean) SQL 2000 machine that has never had SQL 2005 components installed. It worked fine on the SQL 2000 machine. But when I try to open it using the SQL 2005 designer that I downloaded I get the same annoying error. HOWEVER, certain older packages from that same clean SQL 2000 server CAN be edited and saved using the SQL 2005 designer.

This is WAY buggy. Am I missing a download? What about the backwards-compatible pack I saw with all of the (daunting) SQL 2005 downloads? Is there a sequence to doing this? Do I need to fully uninstall all SQL 2000 components first? Can I then reinstall them?

|||

I'm having the same problem. I never had SQL Server 2000 installed, I installed SQL Server 2005 & Visual Studio 2005, then the SQL Server 2000 DTS Designer Component package, but still get error message to install component when trying to open SQL Server 2000 DTS package.

I unintalled SQL Server 2005, then installed SQL Server 2000, ran Enterprise Manager ok, then installed SQL Server 2005, and then SQL 2000 Enterprise Manager will not run now, then installed DTS Component package, and still get same error message to install component when trying to open SQL Server 2000 DTS package.

Tom E.

|||

I get exactly the same errors and here's what I found... After trying to migrate a DTS package that failed to open I got a somewhat more informative error message out of the report. It stated that the package name cannot contain any of the following characters: / \ : [ ] . =.

It so happens many of my packages have ':', '.' in the names and so apparently they have changed this aspect as well (thanks Bill for the lack of documentation). Anyhow, after renaming the packages I was able to open them (still with errors but it worked) and migrate them. What a pain in the a**!!!

Hope this helps...

|||

I was also having same problem

error message was

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.DtsObjectExplorerUI)

The resolution

First download and install SQLServer2005_BC component for backward compatibility from microsoft

Then Install SQLServer2005_DTS component.

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

It should work.In my case it was successfully leting me edit DTS package developed in SQL Server 2000 version

Thankx

|||

So what is the correct anwer here. It looks like it works for some but not for others. I happen to be one of the others that this does not work for. I've been working with a new box, clean install of the latest and greatest. ( a number of times, by the way. )

Sorry, but this is driving me nuts. Microsoft Support where are you?

|||

Scott,

There is no documented resolution from Microsoft that these forums will be frequented by MS staff.

You should seek support via your MSDN subscription and then PSS as far as I know.

-Jamie

|||

In case somebody else still experience the same problems...

I found help at:

http://support.microsoft.com/kb/917406/en-us

-duke63

|||

Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager.