title: Convert Access Database to SQL Microsoft DTS - Data Type '130' not in mapping file
body: <p>I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the data type of a particular type of field in the access database.</p>
  
  <p>I have taken a look at the access tables in question and they are set up as 'text' with a length of 1. They contain a single Y or N value if populated but can also have a null value.</p>
  
  <p>I have been testing on a single table that contains a field of this type. When I open the 'Edit Mapping' screen the data type is set to -1 so I manually set it to a type of char with a length of 1 and attempt to process the table. This produces the following error message:</p>
  
  <pre><code>[Source Information]
  Source Location : C:\admin\facdata.mdb
  Source Provider : Microsoft.Jet.OLEDB.4.0
  Table: `ACASSCATDEPREC`
  Column: DepBook
  Column Type: 130
  SSIS Type: (Type unknown ...)
  Mapping file (to SSIS type): c:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\JetToSSIS.xml
  
      [Destination Information]
      Destination Location : SERVERNAME
      Destination Provider : SQLOLEDB
      Table: [dbo].[ACASSCATDEPREC]
      Column: DepBook
      Column Type: char
      SSIS Type: string [DT_STR]
      Mapping file (to SSIS type): c:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML
      [Conversion Steps]
      Conversion unknown ...
      SSIS conversion file: c:\Program Files\Microsoft SQL Server\100\DTS\binn\DtwTypeConversion.xml
  </code></pre>
  
  <p>I have been reading various blogs and it seems as if I need to edit the xml mapping files to tell DTS what data type 130 should be so I edited the file <strong>c:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\JetToSSIS.xml</strong> and ran it again but this made no difference.</p>
  
  <p>I added this the xml mapping file and then restarted the program and tried again:</p>
  
  <pre><code>&lt;dtm:DataTypeMapping &gt;
      &lt;dtm:SourceDataType&gt;
          &lt;dtm:DataTypeName&gt;Char&lt;/dtm:DataTypeName&gt;
      &lt;/dtm:SourceDataType&gt;
      &lt;dtm:DestinationDataType&gt;
          &lt;dtm:CharacterStringType&gt;
              &lt;dtm:DataTypeName&gt;130&lt;/dtm:DataTypeName&gt;
              &lt;dtm:Length&gt;1&lt;/dtm:Length&gt;
          &lt;/dtm:CharacterStringType&gt;
      &lt;/dtm:DestinationDataType&gt;
  &lt;/dtm:DataTypeMapping&gt;
  </code></pre>
  
  <p></p>
  
  <p>The fact that I got exactly the same error as before led me to believe that editing the other mapping files wouldnt make a difference.</p>
  
  <p>Anyone any ideas?</p>