Mapping Data Types in SSIS

Posted by

Data types in different environments have different names. Data types in SSIS environment is different from names in system namespace in Microsoft .NET framework.

In data flow of SSIS, maybe we need to use the compenents to convert data types when moving them from sources to destinations.

Here is some sources:

Mapping Data Types in the Data Flow

Also, here are some cheat sheets about data types in SQL Server and SSIS:

String data types:

Integer and Boolean:

Other data types:

Day/time data types:

Floating point data types:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s