Sql Server 2005 possibilities

12 Jan 2006 9:57 AM

Enric

Dear fellows,

We are accostumed to work a lot of time with ETL processes such as DTS. We
have got nearly 1,200 among three servers. Question is easy: Sql2005k
provides us a powerful tool inlayed the own application be able to execute
proficiently any kind of search? For example: statistics about how many DTS
own 'Send Mail Task' or how many are running against Oracle, bla, bla, bla.
Nowadays, anyone can obtain info using DTSpkg.dll through VB but is not
useful at all, is heavy, slow and depens enormously of programming.

Any view or thoughts for this specific need would be much appreciated.

Regards

12 Jan 2006 1:06 PM

Wayne Snyder

Take a look at the sys.sysfiles table...

You could also pull the code out of sp_helpdb which generates the database
size, and in either case simply use the query..

The trouble with sp_helpdb is that it returns multiple result sets... You
can Exec sp_helpdb.. but you will have to process all the result sets..

I would prefer to create/use a query for this...

Ie
select sum(size) from sys.sysfiles --gives the number of pages

--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

Show quote

"Enric" wrote:

> Dear fellows,
>
> We are accostumed to work a lot of time with ETL processes such as DTS. We
> have got nearly 1,200 among three servers. Question is easy: Sql2005k
> provides us a powerful tool inlayed the own application be able to execute
> proficiently any kind of search? For example: statistics about how many DTS
> own 'Send Mail Task' or how many are running against Oracle, bla, bla, bla.
> Nowadays, anyone can obtain info using DTSpkg.dll through VB but is not
> useful at all, is heavy, slow and depens enormously of programming.
>
> Any view or thoughts for this specific need would be much appreciated.
>
> Regards
>
>

12 Jan 2006 2:04 PM

JT

I know this can be done with SQL Server 2000, but not sure about 2005. By
scripting the DTS packages out to VB project and module files (perhaps
automating this step using DMO), you can then use a utility like WinMerge to
perform a text search. Also, WinMerge can be used to compare the contents of
files in seperate folders and display the differences, which is good for
version control and debugging.

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:0ADE0B3C-18EA-49E8-A139-63D1541D9B22@microsoft.com...
> Dear fellows,
>
> We are accostumed to work a lot of time with ETL processes such as DTS. We
> have got nearly 1,200 among three servers. Question is easy: Sql2005k
> provides us a powerful tool inlayed the own application be able to execute
> proficiently any kind of search? For example: statistics about how many
> DTS
> own 'Send Mail Task' or how many are running against Oracle, bla, bla,
> bla.
> Nowadays, anyone can obtain info using DTSpkg.dll through VB but is not
> useful at all, is heavy, slow and depens enormously of programming.
>
> Any view or thoughts for this specific need would be much appreciated.
>
> Regards
>
>