On a recent project that I was working on we came across an issue where we needed to replicate several databases on a new server. Much of the ETL had places where tables were truncated and reloaded. Normally this is not an issue at all, simply TRUNCATE TABLE and away you go. This does however cause a problem when you have a replicated database. According to the Microsoft documentation, which I obviously haven't read all of, you can't use TRUNCATE TABLE where the tables are referenced by a foreig...
Read More
Recently while creating a script to migrate the new holding tables over to the stage and production machines I ran into a little issue. The holding table we are using in this case houses several different sets of data for our migration project. Tables that are used only for going from the old system to the new (which will be going away in a few months) and tables that will be used in the future while on the new system. In order to keep these tables separated we decided put them in different sche...
Want to get a little bit of free SSIS training? Have some free time during lunch to listen to me talk? Join me tomorrow as I present a lunchtime session for SQL Lunch at 12:30 pm Eastern, 11:30 am Central. The topic will be looping in SSIS. It is a great opportunity to learn a new topic if your new to SSIS or brush up on looping if you haven't done it in a while. You will find all the details below. Add to Outlook : Add to Calendar Join Meeting: https://www.livemeeting.com/cc/usergroups/join?id=...