Cannot reference Microsoft.SqlServer.Dts.DtsClient?

Reinstalled SqlServer 2005 and SP2. Reinstalled VS2005 and SP1. I add a reference to Microsoft.SqlServer.Dts.DtsClient. It automatically adds a line to web.config

<add assembly="Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>

I still cannot do

using Microsoft.SqlServer.Dts.DtsClient;

I can do

using Microsoft.SqlServer.Server;

I am thinking a config file or something is missing/corrupt somewhere to prevent me from being able to correctly reference this dll. Can anyone help please?

NoRemorse,

If you're trying to configure the Reporting Service you may find the following helpful: http://msdn2.microsoft.com/en-us/library/ms345250.aspx.

HTH,

Patrik

|||I just want to be able to run an SSIS package from code. I need to have that assembly in order to get at the DTS objects. I did what that article suggested anyway but it still doesn't work. Oddly, if I create a new Windows Form project I can reference the assembly fine, so the DLL seems to be regeistered ok. But in a Web project I cannot reference it.|||I uninstalled VS team system and now it works fine. Some incompatibility there

Cannot limit results with ReportViewer

Hello,
I have been attempting to set up a report using the ReportViewer
control in VS2005. The report graphs the TOP X number of records based
on certain criteria. Naturally, I modified the report with a filter
for the TOP N results. This works, however, in the case of ties on the
last entry, all tied instances will get graphed. In my case, this may
be alot of entries causing the bar graph image to display unreadable
data since there are too many result to graph.
So, I attempted the following with no success since the server is SQL
2000 and not SQL 2005:
- Using the TOP keyword in the select query does not work with a
parameter (ie SELECT TOP @.rowcount FROM...) since I am using SQL 2000.
- I cannot use a stored procedure and use the "SET ROWCOUNT" command
with the select query.
- I cannot use the LIMIT keyword in SQL 2000.
Can anyone come up with a solution, other than upgrading to SQL 2005?
Thanks in advance,
Andrewcheck this one......
SELECT w1.CATEGORYID, w1.UNITSINSTOCK,COUNT(*) As Rank
FROM
(SELECT CATEGORYID, UNITSINSTOCK
FROM PRODUCTS
GROUP BY CATEGORYID, UNITSINSTOCK ) AS w1
INNER JOIN
(SELECT CATEGORYID, UNITSINSTOCK
FROM PRODUCTS
GROUP BY CATEGORYID, UNITSINSTOCK ) AS w2
ON w1.CATEGORYID = w2.CATEGORYID
AND w1.UNITSINSTOCK <= w2.UNITSINSTOCK
GROUP BY w1.CATEGORYID, w1.UNITSINSTOCK
HAVING COUNT(*) <=@.parameter
ORDER BY w1.CATEGORYID,w1.UNITSINSTOCK DESC
Regards
Dinesh
therealbigcoops@.gmail.com wrote:
> Hello,
> I have been attempting to set up a report using the ReportViewer
> control in VS2005. The report graphs the TOP X number of records based
> on certain criteria. Naturally, I modified the report with a filter
> for the TOP N results. This works, however, in the case of ties on the
> last entry, all tied instances will get graphed. In my case, this may
> be alot of entries causing the bar graph image to display unreadable
> data since there are too many result to graph.
> So, I attempted the following with no success since the server is SQL
> 2000 and not SQL 2005:
> - Using the TOP keyword in the select query does not work with a
> parameter (ie SELECT TOP @.rowcount FROM...) since I am using SQL 2000.
> - I cannot use a stored procedure and use the "SET ROWCOUNT" command
> with the select query.
> - I cannot use the LIMIT keyword in SQL 2000.
> Can anyone come up with a solution, other than upgrading to SQL 2005?
> Thanks in advance,
> Andrew

Cannot integrate SQL Server 2005 with Visual Studio 2005

Hi,

I have a question that I hope someone can help me with.

I' have installed VS2005 Beta 2 on my XP machine. I've also installed SQL Server 2005 and uninstalled SQL Express (though the instance still seems to appear even though it no longer works!)

So basically I'm trying to get VS2005 to work with SQL Server 2005. However when I go into solution explorer, I :-

Right click on the project name
Select ADD
NEW ITEM
SQL Database
<name.mdf>
now from what I've seen in online demo's, it should then fire up some connection wizard. Mine just sits there for about 30 seconds and then tells me it's timed out. I then find the .mdf file added to my project is totally useless and hangs for another 30 seconds everytime I select it until I delete the thing.

In server explorer, I type in the name of my server (my PC's name) and the test connection appears to work fine.

Can anyone tell me why this is happening and how I can fix it?

Many thanks in advance

Jocky.

It sounds like you've got some registry badness going on. De-install all SQL Server, following this link:

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

And then reinstall. That should clear it up for you.

Buck Woody

Cannot integrate SQL Server 2005 with Visual Studio 2005

Hi,

I have a question that I hope someone can help me with.

I' have installed VS2005 Beta 2 on my XP machine. I've also installed SQL Server 2005 and uninstalled SQL Express (though the instance still seems to appear even though it no longer works!)

So basically I'm trying to get VS2005 to work with SQL Server 2005. However when I go into solution explorer, I :-

Right click on the project name
Select ADD
NEW ITEM
SQL Database
<name.mdf>
now from what I've seen in online demo's, it should then fire up some connection wizard. Mine just sits there for about 30 seconds and then tells me it's timed out. I then find the .mdf file added to my project is totally useless and hangs for another 30 seconds everytime I select it until I delete the thing.

In server explorer, I type in the name of my server (my PC's name) and the test connection appears to work fine.

Can anyone tell me why this is happening and how I can fix it?

Many thanks in advance

Jocky.

It sounds like you've got some registry badness going on. De-install all SQL Server, following this link:

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

And then reinstall. That should clear it up for you.

Buck Woody