Showing posts with label release. Show all posts
Showing posts with label release. Show all posts

Wednesday, March 21, 2012

Dundas Charts in SSRS 2005

In a press release ( http://www.microsoft.com/presspass/features/2007/jun07/06-04sqlserver.mspx) It statedthat "...Microsoft licensed our Dundas Chart for .NET technology for inclusion in SQL Server Reporting Services 2000 and 2005 (SSRS)..."

Does that mean that I can download Dundas Charts for free ? - and where is the link ?

If not then what does it mean ?

If it is anything like what they used to do with VB and 3rd party controls:

The 3rd party vendor would supply a cut down version for inclusion with the MS tool.

Anyone who wanted the full functionality would have to buy it from the company.

There are some good tips on charting here

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rch7rptslnpatternrecipes.mspx

Friday, February 24, 2012

DTS: How to connect to hundreds of DBs dynamically

I need to release a few triggers and procedures to hundreds of databases
with the same structures.
I try the Dynamic Property in DTS, create an "Execution Task", add a
connection property with a source type as "Query", and the query is like
"select the database name from master..sysdatabases where name not in
('master','model','temp')".
Unfortunately, the package runs only on the first DB in the query.
How can I make it run on each of all databases?
Thank you.Create a connection to the server,
create an "Execute SQL Task" with your databases query in it -
in the "Output parameters" tab of the sql task use a rowset output
then loop through the values in an ActiveX script to perform your jobs.
http://www.sqldts.com/default.aspx?298
"Jluo" <jluost1@.yahoo.com> wrote in message
news:4224B876.5000304@.yahoo.com...
> I need to release a few triggers and procedures to hundreds of databases
> with the same structures.
> I try the Dynamic Property in DTS, create an "Execution Task", add a
> connection property with a source type as "Query", and the query is like
> "select the database name from master..sysdatabases where name not in
> ('master','model','temp')".
> Unfortunately, the package runs only on the first DB in the query.
> How can I make it run on each of all databases?
> Thank you.
>