This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.
2010-11-16
861 reads
In an ETL solution, error logging is a fundamental requirement for various aspects of the application and is very useful at various stages of the ETL execution life-cycle. Let's consider a scenario where our requirement is to insert records into a SQL Server table. The package should attempt loading all the records and whichever records fail, error details reported by the database engine should be reported. We will look at how to implement this in a SSIS package.
2010-11-16
3,997 reads
A free day of training in New York City just before Thanksgiving. Come see Steve Jones and Grant Fritchey, along with a number of other great speakers.
2010-11-16 (first published: 2010-11-04)
2,471 reads
Steve Jones outlines some ways that you might look to get additional training that can help move your career along.
2010-11-15
3,705 reads
Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This article provides a step by step guide to setting up transactional replication on SQL Server 2008 R2.
2010-11-15
2,436 reads
Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.
2010-11-12 (first published: 2009-07-13)
10,647 reads
On Nov 16, 2008, the Luxembourg SQL Server User Group will hold a SQL Server 2008 R2 event in conjunction with Microsoft.
2010-11-12
367 reads
In a previous tip, we did an overview of Extended Events and the different components that make up Extended Events. Now that you know what Extended Events offers, how do you use it to help troubleshoot performance issues? In this tip we take a step by step look at how to implement and use Extended Events.
2010-11-12
2,644 reads
How to set the default locations for backups, data files, and log files in SQL Server.
2010-11-11
8,572 reads
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-11
2,035 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers