SSIS Data Types

This is a useful guide on MSDN for mapping SSIS Data Types to that of various databases.

http://msdn.microsoft.com/en-us/library/ms141036.aspx

The top part is an explanation of each SSIS data type. Further down is a mapping of various databases (notably SQL Server, Oracle and DB2) data types to SSIS types.

Brian Knight has a nice grid mapping SSIS Types to SQL Server which is a little easier to read for those working in a pure SQL Server environment.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>