Ryan Garaygay
(1 votes, average: 5 out of 5)
Loading ....NET Developer Notes » DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Fuzzy Lookup" (60) failed with error code 0xC0202009 while processing input "Fuzzy Lookup Input" (61)
Encountered this error in one of recent tasks involving SSIS Fuzzy Grouping and Lookup. [Fuzzy Grouping Inner Data Flow : SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Fuzzy Lookup" (60) failed with error code 0xC0202009 while processing input "Fuzzy Lookup Input" (61). The identified component returned an error from the ProcessInput method. The error is specific … [Link]
.NET Developer Notes » Safety settings on this machine prohibit accessing a data source on another domain
Encountered this message many times with sites using PivotTable component of OWC11 (office web components) "Safety settings on this machine prohibit accessing a data source on another domain" This is a browser restriction (at least with IE). Before resolving this, make sure you are accessing a trusted site. Resolution: 1. Add site to the zone (e.g. it is recommended that … [Link]
.NET Developer Notes » Philippine broadband connections affected by damaged pan Asian cable
From SMART/PLDT: Telecom services provider Smart Communications said a pan-Asia cable cut early Wednesday caused adverse disruptions in its international and broadband services. In a statement, Smart stressed the disruption affected its international voice and SMS services. Its Smart Bro and Smart Bro Plug-It services are also affected by the cable cut, which was reported to have happened around 10 … [Link]
.NET Developer Notes » 24 hours of high quality sql server training for free
The Professional Association for SQL Server or popularly known aka PASS, one, if not the most popular and biggest group of SQL Server professional in world will be having 24 hours of PASS - a series of online web meetings with the best speakers in the industry Join us online on September 2, 2009* for 24 hours of free, nonstop … [Link]
.NET Developer Notes » Free Web Hosting for Filipino Developers
If you are a Software Developer, Filipino (by nationality or by heart), looking for a little space for hosting your site or blog or simply for testing and practice purposes I might be able to offer you a few MB (starting at 200 MB, in my experience this is more than enough) and one unlimited size MSSQL/MySQL and probably 2GB/month … [Link]
.NET Developer Notes » Upcoming Blog Topics
Some of the topics to watch out for soon (have been in my queue for sometime). In no particular order. Soon, but if you have issues related to below and might need additional information feel free to contact me. * AJAXControlToolkit ModalPopupExtender, Google Chrome and z-index * delegate/anonymous method cannot be deployed to SQL (SQL CLR) * RedGate SQLDoc (this … [Link]
.NET Developer Notes » Let's Support Earth Hour 2009
Please support Earth Hour 2009. Turn off your lights or reduce energy usage on March 28, 2009 (Saturday) 8:30 - 9:30 PM. Or better yet, know and get involved and take action about climate changes and how to preserve our precious planet. Earth Hour Official Website [Link]
.NET Developer Notes » philippine domains limited one year registration offer
** Philippine (.PH) domains are now available for one year registration (as opposed to being previously available in two-year registrations only). But only for a limited time so grab your .PH domains by clicking HERE now. We are now offering one year domain registrations at $38.00 for a limited time (March 10, 2009 to April 30, 2009). This offer is … [Link]
.NET Developer Notes » define programmer
1) pro·gramÂ&middo~ (n) An organism capable of converting caffeine into code. 2) Semi-sentient being who inexplicably survives an extremely unhealthy lifestyle. Usually found in confined spaces with low lighting, at a computer terminal. 3) One who can read the following example if( !User.IsProgrammer ){ return "Everyone Else"; } Taken from UrbanDictionary [Link]
.NET Developer Notes » Link: IE 8 Release Candidate 1
"Internet Explorer 8 has been designed from the ground up to be enterprise-ready. It helps reduce security risk through features such as a cross-site scripting filter, the SmartScreen® Filter, and safer controls and management of the Microsoft® ActiveX® technologies, platform, controls, scripting, and server framework. And when you download the latest RC1 software, you're automatically registered to access valuable RC1 … [Link]
.NET Developer Notes » TSQL to get SQL Server properties
TSQL script to get common SQL Server properties (edition, instancename et al) SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName~ InstanceName, SERVERPROPERTY('IsClustered'~ IsClustered, SERVERPROPERTY('IsFullTextInsta~ IsFullTextInstalled, SERVERPROPERTY('IsIntegratedSec~ IsIntegratedSecurityOnly, SERVERPROPERTY('IsSingleUser~ IsSingleUser, SERVERPROPERTY('IsSyncWithBacku~ IsSyncWithBackup, SERVERPROPERTY('LicenseType'~ LicenseType, SERVERPROPERTY('MachineName'~ MachineName, SERVERPROPERTY('NumLicenses'~ NumLicenses, SERVERPROPERTY('ProcessID') ProcessID, SERVERPROPERTY('ProductVersion&~ ProductVersion, SERVERPROPERTY('ProductLevel~ ProductLevel, SERVERPROPERTY('ServerName'~ ServerName Taken from: http://sqlserver-qa.net/blogs/t-sql~ [Link]
.NET Developer Notes » My Simple Talk article on ANTS Profiler and Performance
A couple of weeks back, RedGate/SimpleTalk contacted me for a short article about ANTS Profiler. I've been using it for sometime and has definitely been very useful so I won't think twice about recommending it. Here's the link (below) and please do drop by to read it. Feel free to rate/comment Using a profiler to speed (up) application Performance [Link]
.NET Developer Notes » language translation for this site
To be able to share to a wider audience I have placed Google Translation gadget at the upper left side of these pages. I'm a frustrated linguist and I will try my best to write in a way that will likely to produce correct translation but forgive me if I don't. Hopefully soon I can understand your languages too. It … [Link]
.NET Developer Notes » Suspected Trojan or Virus qxty9be.cmd
Suspected Trojan is messing up my PC at this very moment I attached my portable drive to a computer that didn't have antivirus today. The computer was working fine (at least as it seems) but I found a certain "autorun.inf" and "qxty9be.cmd" in that diks afterwards. I scanned the disk and Symantec didn't see anything! However in my attempt to … [Link]
.NET Developer Notes » GoDaddy IIS7 DotnetNuke Joomla WordPress
UPDATE (2/2/09): GoDaddy even on deluxe/premium/unlimited hosting accounts, applications (eg. .NET application root) is configured as virtual directories. Thus the ApplicationRootPath is still rooted on the ROOT of the hosting disk space. This makes sense I think and so even if domain points to say ROOT/subfolderA, Response.Redirect("~/Page.aspx~ will still point to /subfolderA/Page.aspx and it will appear as such in the … [Link]
.NET Developer Notes » SubSonic and Club Starter Kit
If you don't code generate your DAL or use OR/M or anything that would make you worry less about DataAccess like LINQtoSQL, Entity Framework, NHibernate, Castle ActiveRecord then you should definitely give SubSonic a shot. On the side I'm currently working on a C# version of Extended Club Starter Kit Version 3 Beta 1 for one club that I was … [Link]
.NET Developer Notes » Get Ancestor and Descendant IDs or info using SQL 2005 Common Table Expressions
Need some recursive processing in TSQL (SQL Server 2005)? Needed some TSQL code again to retrieve descendant and ancestor entries in a self-referencing table. I've done this a couple of times already and although I can write on top of my mind, sometimes you just want to make life easier and have a script you can just modify a bit … [Link]
.NET Developer Notes » Lost Internet Access due to ZoneAlarm and Microsoft Update KB951748
I ran into this issue a while ago where I lost internet access connection after installing a windows update and turns out to be because of my ZoneAlarm installation. [more] Overview: Microsoft Update KB951748 is known to cause loss of internet access for ZoneAlarm users on Windows XP/2000. Windows Vista users are not affected. Impact : Sudden loss of internet … [Link]
.NET Developer Notes » LINQ to SQL and Visual C# Developer Express Data Source Connections
While I was evaluating a couple of things including LINQ to SQL (or L2S to some) for a small website I tried to look into whether it was possible to have the LINQ to SQL classes on a separate project (eg. DAL) rather than the website itself. [more] Since Visual Web Developer Express Edition (you need 2008 for LINQ to … [Link]
.NET Developer Notes » Investing in a Quality Programming Chair
Been quite busy lately work and off work (research ofcourse primarily in urlrewriting) but I couldn't help but notice and comment on a post from CodingHorror/Jeff Atwood on this topic [more] Read his post on Investing in a Quality Programming Chair I could very much relate to this (not to mention that somehow I'm particular about productivity and ergonomics). Though … [Link]
