Our scanning application output files to an invalid directory. The path settings were set to [LastName], [FirstName] [IDNumber]. The problem was the data did not have any values in the IDNumber field. So, the directory […]
Learned a lot about SQL Server Integration Services (SSIS) and ETL packages in the last few days… I have 36,934 XML files in several subdirectories that needed to be imported into a SQL database so […]
I have a string value in a column in my table. It’s a full path and filename for a .tif image. I needed to get just the filename as a column. I couldn’t use a […]
I recently needed a lookup table of all 50 US states (and Washington DC) and the provinces / territories in Canada. The script below will create a table (tbl_LUState) and will populate the table with […]
We are working on a special project for an existing client. We’ll be scanning hundreds of thousands of documents over the next year to year and a half. The delivery of the digital images will […]
I have a folder of Macros that I use from time to time. Until recently I would open my new spreadsheet, go into Visual Basic mode and copy/paste the macro into the spreadsheet. Save it […]
I had a spreadsheet that was in .xlsx format that I needed to import into an Access Database. I made sure the columns were in the correct order, and that the column headers matched my […]
We at Bradford use Google Apps for our email. My computer not part of the domain (I don’t’ work from the corporate office) and we don’t have our own internal SMTP server in our domain […]
Recently I needed a way to essentially ‘loop’ through all the records in our NetTrax.NET Audit History for the given record and return back the one that is that entries ‘check in’… So, what I […]
Often we send a database to a client and then later on find out that a key got dropped or an index removed along the way… Well, now we can easily test this! Open up […]