Since I've been using SVN and stumbled upon this technique I've also been using since then
This is one of the many (but easiest way) to remove SVN folders (.svn) recursively from a given folder. Effectively "unbinding a folder from SVN"
Follow these easy steps: More...
As most of you know the general rule in performance tuning is .....
"measure, measure, measure" and "measure again"
But it doesn't hurt to give out some warning signs from time to time. And here goes two: More...
Just very recently I encountered an issue in deploying a custom SSIS component assembly where I cannot add a custom SSIS transformation to the Visual Studio toolbox.
It turns out to be a relative "no-brainer" error if only the clues were more straightforward. Basically after deploying the assembly I could not find my component listed in the "SSIS Data Flow Items" tab list. More...
I have recently consolidated some of the sites I maintain into one of my hosting accounts. (will post about the provider soon - so far so good)
And that includes this blog. Along with this move I have also updated to the latest version of BlogEngine.NET - guilty of not being up to date for a couple of reasons:
Anyways, here are some notable changes: More...
We are currently looking for a SQL BI Developer Professional to work with us on exciting, high-profile/scale projects. Feel free to contact me or visit http://www.lwsmedia.com/contact.htm. Looking forward to work with you. More...
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 to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
[Fuzzy Grouping Inner Data Flow : SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
[Fuzzy Grouping [800]] Error: A Fuzzy Grouping transformation pipeline error occurred and returned error code 0x8000FFFF: "An unexpected error occurred.".
This is the only relevant error message or code that I got and didn't seem quite helpful. More...