SQL Server SSIS Articles

Shared Datasets in SQL Server 2008 R2

This article leverages the examples and concepts explained in the Part I through Part IV of the spatial data series which develops a “BI-Satellite” app. Overview In the spatial data series we looked at free-form text based address data and worked towards developing a Geospatial Dashboard . In this artilce we will look at using […]

Achieve Spatial Data Support in SSIS

Overview SQL Server 2008 introduced a new category of datatypes known as spatial datatypes which store spatial information. The new spatial datatypes are geography and geometry. SQL Server Management Studio comes with good good support for these spatial data types like the spatial results tab and facilitated access to .NET Common Language Runtime (CLR) functions […]

Working with Spatial Data Part III – Reporting Spatial data using Reports Builder 3.0

Overview Development of any analytical solution normally ends with a form of  report, whether it is a normal tabular report or a sophisticated interactive dashboard.   In the first part of our BI-Satellite project, we devised a way to geocode location based spatial data using SSIS and Bing Maps. Thereafter in the next part we plotted […]

Working with Spatial Data Part II – Plotting Shapes and Storing Geocoded Data

This article leverages the examples and concepts explained in the first part of this spatial data series which develops a “BI-Satellite” app ( Geocoding Text-Based Spatial Data for Use In SSIS Packages Part-I ) Overview Text based location information is the starting point for spatial data analysis, but this information is generally not directly consumable […]

Using The Data Mining Query Task in SSIS

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS I discussed how to use the Analysis Services Processing Task to […]

The Excel Connection Manager is not supported in the 64-bit version of SSIS

When you attempt to execute an SSIS package which has a Excel Destination/Source in SQL Server 64 bit , you will get following error. [Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. As […]

Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using WMI Data Reader and WMI Event Watcher Tasks in SSIS I discussed how to use the WMI Data Reader and WMI Event Watcher […]

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

When searching the Web for solutions to use SQL Server 2005’s Integration Services to convert and load EBCDIC (IBM Mainframe) data, many will hit a massive roadblock. Through exhaustive searches you may be able to return a minimal amount of information, none of which will likely pertain to performance tuning once a conversion solution is […]

Using The Transfer Jobs Task in SQL Server Integration Services

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS I discussed how to use the Transfer Error Messages Task […]

Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers and administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS I discussed how to use the Transfer SQL Server Objects […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |