Tag Archives: SSIS

Execute Multiple 2008/2005 SSIS Packages with a T-SQL

If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this using T-SQL. First you will  need a table with all of your package names on it. Then a While loop … Continue reading

Posted in SSIS, Syndication, T-SQL | Tagged | 6 Comments

Sorting a String as a Number with T-SQL and SSIS

I was working on a Cube in Analysis Services for a client recently and needed to sort on a field that was a varchar but contained numeric data. I wanted to sort as if it was numeric. I could not … Continue reading

Posted in SSIS, Syndication, T-SQL | Tagged , | 2 Comments

Monitoring SQL Server with SSIS

SQL Server can be monitoring with SSIS packages using the DMVs in SQL Server. I did a webinar on this and you can watch the video at PragmaticWorks.com under the webinars page. You can download the code for this webinar … Continue reading

Posted in SSIS | Tagged , | 28 Comments

Setting up SSIS Auditing Part 2

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SQL PASS Summit 2011 The Aftermath

I just returned from Seattle, WA and my first time speaking at SQL PASS Summit. I did the SQL Smackdown T-SQL vs SSIS Loading a Data Warehouse with Adam Jorgensen. The session was a hit, it was standing room only … Continue reading

Posted in PASS, SSIS | Tagged , , , | Leave a comment

Setting up SSIS Auditing Part 1

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading

Posted in SSIS, Syndication | Tagged | 1 Comment

Using Configuration Tables in SSIS 2008/2005

SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations start out creating SSIS package one by one until they have dozens, hundreds, or even thousands of packages. I have … Continue reading

Posted in SSIS, Syndication | Tagged , , | Leave a comment

SSIS For Each Column in a Data flow

Previously I wrote a blog on how to do a for each loop to look through each col in an SSIS data flow here. Well things have changed since I wrote that blog, in fact I believe that old  code … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SSIS Merge with Duplicate Rows

The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The question arises, what about duplicate records. These duplicates do not get eliminated. Here are two tables with the ID 5 … Continue reading

Posted in SSIS, Syndication | Tagged , | Leave a comment

SSIS Child Errors in Parent Package

If you have a parent package that is looping through a set of files and calling child packages and want the parent package to continue even if the child package fails, there is a little work involved in making this … Continue reading

Posted in SSIS, Syndication | Tagged , , | Leave a comment