Category Archives: SSIS

SSIS Execute SQL error – No disconnected record set is available

If you get the error in SSIS that says: …failed with the following error: “No disconnected record set is available for the specified SQL statement.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SSIS Pivot on bad data

The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even worse. In this blog I am going to show how to handle bad data when using the pivot transform. You … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SSIS Records on the Same Row – kind of like pivot

If you have two or more records on the same row, and need to write each record on its own row in a destination, you have two choices. You can do this in series or parallel in a single data … Continue reading

Posted in SSIS, Syndication | Tagged | 1 Comment

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