keanehan di SSiS2005

ada yang aneh di ssis 2005.
gw mo ambil ole db source langsung tembak ke view dbo.ax_d_engagement_all di database interface, server idjakameyapps03 (sql2000enterprise). ga berhasil.
accessmode=openRowset
rowset=dbo.ax_d_engagement_all

di cek di activity manager, cuma ada 2 koneksi [select * from dbo.ax_d_engagement_all] yang ga kelar2 jalannya.

lalu gw ganti ole db sourcenya menjadi
accessmode=SQL Command
SqlCommand=[select * from dbo.ax_d_engagement_all]
cuma butuh 19 detik dowank untuk komplitnya

duh, sungguh aneh...

check /3gb with wmic

If you are like me, got some 32bit server with 4 Gigs of Ram (max for standard edition of 32bit WinServer2003), You will love to put "/3GB" in your windows startup parameter. But, how to ensure that this switch already working?

I got solution in this page, look in comment #1.
Whether you use WinServer2003 or windowsXP, you can use the same method (I not use Vista yet, so I cannot checked it).

The Syntax is:
wmic /node:<insert_server_name> OS get MaxProcessMemorySize

or, for example, in my computer it will be
wmic /node:JK080251 OS get MaxProcessMemorySize

In my XP machine (2 Gigs of RAM) i got 2097024.
In my /3GB server (4 Gigs of RAM) I got 3145600.

seek for dependencies

in sql server 2000, looking for sql dependencies is not that easy.
at least in my humble opinion.

I try to compile from various sources, and this is the result:

/* version 0.90 */
declare @cariIni varchar(150);
set @cariIni = 'vw_d_engagement_all'

--//table 1//
select routine_name, routine_type from information_schema.routines
where routine_definition like '%'+ @cariIni +'%'

--//table 2//
select routine_definition from information_schema.routines
where routine_name like '%'+ @cariIni +'%'

--//table 3//
exec sp_depends @cariIni

--//table 4//
select distinct so.name, so.type
from syscomments sc inner join sysobjects so on sc.id = so.id
where charindex(@cariIni, text) > 0

--//table 5//
exec sp_MSdependencies @cariIni, null, 131527

--//table 6//
exec sp_MSdependencies @cariIni, null, 1053183

expect me to update this procedure in next following days..

scribeFire

testing ngisi webblog blogger/blogspot via scribeFire 2.3 di fireFox 3.0.1

First abs Blog on Software

just first blog on software..