SSIS Skip Rows in Excel Source file
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search608 entries
Parse a HTML Table into a ListView
A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView.
A picture of the Internet
Just a pretty picture on how hackers have created an infographic of the internet: Source: BitBucket.Org - Internet Census 2012
Country Lookup by IP address CSV
So this is an article to serve as documentation for one of the data sources available to download for FREE from this site.
SSIS Convert a string into a date
Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European D...
Restore MSSQL Error: Database is in use
This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well.
Fix Oracle Tnsping 3511 without Windows Registry
So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file f...
Administrator Program Shortcut without Prompt
I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we'r...
Convert Decimal (Person Days) to Time in Excel
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join.
Loading more notes...
No more notes to load.