Monthly Archives: September 2011

White Paper – Troubleshooting SSIS

..My SSIS White Paper has been published! Download the White Paper and the Sample Files here. “SSIS is a fantastic Microsoft tool for performing Extract Transform and Loading (ETL) procedures. A challenge in SSIS is identifying a problem once you … Continue reading

Posted in SSIS | Tagged , , | Leave a comment

Handling Flat File Headers and Errors in SSIS

Using SSIS to load a flat file into a database is a common use of the tool. This works great in SSIS and is very fast due to the dataflow doing batch updates. This is easy to set up when … Continue reading

Posted in SSIS, Syndication | Leave a comment

SQL Saturday Orlando – Pre Con

I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works … Continue reading

Posted in SQL Saturday, Training | Tagged , , , , | 2 Comments

Using the SSIS Merge Join

The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There are a few requirements to join these two data sources. The data sources … Continue reading

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

Pragmatic Works Foundation Class Oct 2011

I am super excited to announce that there is a strong demand for the Foundation Training to be held more frequently.  Our last one was held in August and several people were hired for Jr. DBA and Report Writing opportunities.  … Continue reading

Posted in Foundation, Training | Tagged , , | Leave a comment

Variables and Expressions with Connections in SSIS

Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables in a package, especially when the information is used more than once in the package. In any package you will … Continue reading

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