Experiments, tutorials and ideas on developing business intelligence solutions
Hi In this post I would like to quick share a technique which has often come handy in my day-to-day development work. At times when building SSIS package, I have to connect to S/FTP server to download/upload files and the server rejects the connection being busy, or if I have to loop and wait for Read More …
In Australia we have weather information published on the BOM (Bureau of Meteorology) website, and as often needed we get the historical/forecast data-sets from this portal. One usually has few options around this: If the data requirement is one-off for any particular analysis or requirement Look for a download option on the portal (CSV usually) Read More …
Hi, Well I believe this post is going to be fancy, but yet quite productive one. In a team where the members are over-burdened with task, and yet they are asked to create TFS work-items for each relevant email which has the associated task for them. They kinda not happy with the effort and wish Read More …
Hi, This is my new article on the VSTS (Visual Studio Team Services) automation. VSTS is a popular and a very important tool in any organisation where by the developer can version their code, manage work, documentation relating the project and much more. Recently i wrote an article SQL – Backup Database Schema and SQL Read More …
Hi, In this post I would like to share the bulk insert methodology via C# rather than using SSIS. In the first place, why would i do that ??? Hmm… Well i cam across this situation when I am working with substantially large data-sets, the strategy to process them as fast as possible is to Read More …