SSIS - Tools for checking which data type mapping file is being used
Does anyone know if there's any tools that one can use to determine which
datatype mapping file is being used in SSIS 2012.
I've tried using Process Monitor but it looks like SSIS parses through
every single file found in C:\Program Files (x86)\Microsoft SQL
Server\110\DTS\MappingFiles to find an appropriate file to use.
I have a new mapping file that has 3 protocols under sourcetype:
SourceType="SQLOLEDB;SQLNCLI*;System.Data.SqlClient.SqlConnection"
However, only the datatypes for SQLOLEDB and SQLCLI* protocols are being
mapped according to what's stated in the new mapping file. Most of
datatypes for System.Data.SqlClient.SqlConnection are mapped correctly
except for 2 datatypes which I cannot determine why.
Can anyone give some advice on any tools/techniques that I can use to
troubleshoot this problem?
Note: In case anyone is wondering, I did restart SSDT / Import Export
Wizard before each verification is done.
Thanks in advance.
No comments:
Post a Comment