A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.  Read more...

Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.  Read more...

A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.  Read more...

A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.  Read more...

This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.  Read more...

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...  Read more...

This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.  Read more...

In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.  Read more...

A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.  Read more...