Category Archives: SSIS

Loop Through Excel Files in SSIS

You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow task. First Create a variable named strExcelfile as a string variable; you can leave the value blank. Next, drag in … Continue reading

Posted in SSIS, Syndication | Tagged | 17 Comments

Handling Large Many to Many bridge tables

In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of the problems that arise from many to many bridge tables are the size of these tables. In this example we … Continue reading

Posted in SSAS, SSIS, Syndication | Tagged , | 1 Comment

Execute SSIS Packages with a Macro in BIDS

When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS to run a package. One problem that can occur when using this button is the deployment of project and the … Continue reading

Posted in SSIS, Syndication | Tagged | 1 Comment

Environment Variables in SSIS Packages and Configuration Tables

Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages from a single change. But one of the issues with configuration tables is the location of the server is different … Continue reading

Posted in SSIS, Syndication | Tagged | 4 Comments

Pivoting weird data in SSIS – Sort of…

Sometimes we get data in some bad forms. For example look at the below table: The names and the amounts are comma separated in two different columns. Let’s imagine we need to get this data into a table like the … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

AS400 Program from SSIS

If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an Execute SQL Task. This can be made even easier with two variables and an expression too. The AS400 program QCMDEXC … Continue reading

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

Bulk Insert Task SSIS – Path Specified Cannot be Found or File Does Not Exist

When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist or The Path Specified Cannot be Found. This is usually due to the fact that the file must be on … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

Studying and Learning Business Intelligence

I have been doing interviews for Pragmatic works for the past few years and I have come across quite a few people who wanted to be hired as a senior BI consultant and their skills were just not up to … Continue reading

Posted in Business Intelligence, PASS, Pragmatic Works, SSAS, SSIS, SSRS, Syndication, Training | Tagged , , | 2 Comments

IT Pro Camp Jacksonville 2012

I spoke last weekend (6/16/2012) at the first ever IT Pro Camp in Jacksonville Florida. It was a great event with over 100 people attending. Breakfast and Lunch was provided with a great after event at Tilted Kilt. One of … Continue reading

Posted in SSIS, T-SQL, Training | Tagged | Leave a comment

SSIS 2012 Copy or Duplicate Environments

In SSIS 2012 there is a great new feature called environments. They can be thought of as a collection of parameters or variables. One of the questions I get asked when teaching SSIS 2012 is “Can I duplicate an environment?”. There … Continue reading

Posted in SSIS, Syndication | Tagged , | 10 Comments