Category Archives: SQL

Training Partner–Database Primary Key Format

If you have spent any time in the Training Partner database, you probably seen something like the following in the STUDENT_NO, ORG_NO and COURSE_NO fields: STUD2010112613253401751458 ORGA2010112613292507201627 COUR2010112613241906691320 These are the primary keys (or unique ids) for a student, organization and course respectively. All primary keys within the Training Partner database have the same format. […]

Also posted in Training Partner | Tagged , , | Leave a comment

SSIS Data Task Failure Not Executing Error Control Item

Another simple solution that took me about 1 hour to figure out. I have a simple SSIS package that imports a flat file to a database table, performs a stored procedure on the imported data and moves the processed file into an archive folder. If the import failed, I wanted the file to be moved […]

Posted in SQL | Tagged , | 13 Comments