This table stores the data type mapping of sql server and
SSIS data type.
SELECT [mapping_id]
,[ssis_data_type]
,[sql_data_type]
FROM [SSISDB].[internal].[data_type_mapping]
|
See the below
Sunday, 16 April 2017
Data type mapping table in SSISDB
Subscribe to:
Posts (Atom)
Popular Posts
-
Delay Validation Property is available on Task level, Connection Manager, Container and on Package level. By default the value of this pro... -
There are multiple ways to run the SSIS package. Refer my previous post where I explain the multiple ways to schedule our SSIS package. I... -
Suppose you have excel and in that excel we have a column that contains mixed data type (like number, date, string etc.). While we are try... -
The RecordSet destination does not save data to an external data source. Instead, the RecordSet destination saves data in memory in a Reco... -
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There ...