Evan Koch

Recently I worked with another consultant on trying to import data from a flat file into a SQL Server 2005 database. There were issues loading the file using the SSIS Import and Export Wizard, howe…

It’s useful from time to time to be able to call external functions within business rules. Instead of something like this:

When dealing with existing systems, sometimes a challenge presents itself in the form of a flat file. Trying to impose structure upon a flat file can be achieved, however, using the Table Looping a…