Member Login
 
 
 
Current Poll
Which Business Intelligence tool do you use most often?





Archived polls...

Site News
:: Upgraded front end of archive application from ASP.NET to Silverlight. -  January 09, 2011.

:: Check out my ETL solution implemented with classes. Alternative is to use SSIS. -  August 08, 2010.

:: Included additional SEO enhancements; Sitemap.xml, robots.txt and meta tags. -  February 04, 2010.

:: Finished upgrades for Search Engine Optimization. Incorporated url rewriting and content relocation. -  November 02, 2009.

More news...

Follow Me

Article List

Filter by category     Articles per page:

Posted by: jbrenes, on 11/2/2010, in category "Software Samples"
Views: 33 times
Location: Fort Lauderdale, FL, United States

Topics covered: Windows,C#.NET

Abstract: The purpose of SSIS is to create packages for ETL (Extraction-Transform-Load). Packages are usually run from SQL Server which makes it difficult to dynamically pass values to the package while it is running. I created an SSIS package to read a file, process it and post the results to a database. The path to the file is passed dynamically to the package through a windows interface. The package has the same functionality than an ETL program I previously developed with code (C#) and OOP. This ...
Posted by: jbrenes, on 8/8/2010, in category "Software Samples"
Views: 61 times
Location: Fort Lauderdale, FL, United States

Topics covered: Windows,ASP.NET,C#.NET

Abstract: Data is the raw material of any business. Data is produced in-house during the day-to-day activities of the business and usually results from business activities such as the use of entry forms, e-mail and excel documents. On the other hand, data can also result from outside sources such as statements from credit card processing companies, data mining, marketing campaigns and public records from government agencies to name a ...
Posted by: jbrenes, on 11/25/2007, in category "Software Samples"
Views: 25 times
Location: Fort Lauderdale, FL, United States

Topics covered: Windows,VB.NET

Abstract: This is a SSIS solution that extracts name, address and account balance from a 1099Int file and generates bills in Word. An SSIS package extracts the data and transforms it into a comma-delimited file. The comma-delimited file is fed to Word Collaboration to produce bills that can be mailed to clients.
Posted by: jbrenes, on 11/20/2007, in category "Software Samples"
Views: 31 times
Location: fort lauderdale, FL, United States

Topics covered: Windows,C#.NET

Abstract: This sample uses XAML and .NET 3.0.
Posted by: jbrenes, on 11/15/2007, in category "Software Samples"
Views: 14 times
Location: Fort Lauderdale, FL, United States

Abstract: The purpose of this sample is to demonstrate NTier design. The sample has three layers, a Presentation, Business and Data layer. The functionality consist in binding an Access database to a DataGridView. Three main software patterns are used in this sample. A provider model is used in the data layer to support multiple data stores. Business objects are used in the business layer allowing for smooth binding to UI elements. The presentation layer listens to events allowing for a responsive application.
Posted by: jbrenes, on 11/10/2007, in category "Software Samples"
Views: 16 times
Location: Fort Lauderdale, FL, United States

Topics covered: Web,Classic ADO

Abstract: Demonstrates GUI, multi-threading in classic Visual Basic 6.0.
Posted by: jbrenes, on 11/1/2007, in category "Software Samples"
Views: 8 times
Location: Fort Lauderdale, FL, United States

Topics covered: Windows,C#.NET

Abstract: Demonstrates Windows Forms.