title: Filemaker to SQL Server via SSIS
body: <p>I'm using SSIS and trying to import data from Filelmaker into SQL Server.  In the Solution Explorer, I right click on "SSIS Packages" and select SQL Server Import and Export Wizard".  During the process, I use my DSN as the source, SQL Server as the destination, use a valid query to pull data from Filemaker, and set the mappings.</p>
  
  <p>Each time I try to run the package, I receive the following message:
  The "output column "LastNameFirst" (12)" has a length that is not valide.  The length must be between 0 and 4000.</p>
  
  <p>I do not understand this error exactly, but in the documentation for ODBC:
  <a href="http://www.filemaker.com/downloads/pdf/fm9_odbc_jdbc_guide_en.pdf" rel="nofollow noreferrer">http://www.filemaker.com/downloads/pdf/fm9_odbc_jdbc_guide_en.pdf</a> (page 47) it states:</p>
  
  <p>"The maximum column length of text is 1 million characters, unless you specify a smaller Maximum number of characters for the text field in FileMaker. FileMaker returns empty strings as NULL."</p>
  
  <p>I'm thinking that the data type is too large when trying to convert it to varchar.  But even after using a query of SUBSTR(LastNameFirst, 1, 2000), I get the same error.</p>
  
  <p>Any suggestions?</p>