APPENDIX A
Data Types
Data types are simultaneously the lifeblood and bane of data migration. They can literally make or break your ETL process. The first, and indeed the fundamental, aspect of a successful data load process is data type mapping. Quite simply, if any source data is a type that SQL Server cannot understand, then an import is likely to fail.
Therefore (and as a quick refresher course), this appendix presents the data types that you need to understand, first in SQL Server, and then in SSIS.
SQL Server Data Types
Table A-1 is a quick overview of SQL Server data types. I realize that data types are not exactly the most exciting thing ...
Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
