Archive for September, 2009

Converting an EBCDIC file using SSIS

September 23, 2009

EBCIDC data is an 8-bit character encoded (code page) file used on IBM mainfram operating systems such as z/OS, OS/390, VM and VSE as well as IBM midrange computer operating systems such as OS/400. Unfortunately, SSIS out of the box can handle EBCDIC conversion but cannot handle a straight conversion from EBCDIC codepage (37) to ASCII codepage (1252).

Code Project has a fairly good article on using VB.NET to handle the conversion but here is how to handle and load the files using the SSIS interface.



Introduction to SSIS

September 21, 2009

SQL Server Integration Services (SSIS) “is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.”*  Packages are the term used to describe these transformation solutions.  This post will show you how to get started.