title: Error SQL72014: Conversion failed when converting the varchar value to data type int
body: <p>I'm having a problem with inserting test data into a table. I am getting the error listed in the title. I have done a lot of googling without finding a solution. </p>
  
  <p>Within in Visual Studio 2012 solution, I have several projects, one of which is a Database project. I am defining several tables. The one in question is:</p>
  
  <pre><code>CREATE TABLE [dbo].[tblKppHierarchyPcl]
  (
      [ID] NUMERIC(18,0) NOT NULL,
      [Name] VARCHAR(500),
      [PartStructureKey] NUMERIC(18,0) NOT NULL,
      [PartNumber] VARCHAR(500) NOT NULL,
      [ParentPartNumber] VARCHAR(500) NULL,
      [TargetCost] DECIMAL(30,4) NULL,
      [UnitCost] DECIMAL(30,4) NULL,
      [CostMaturityID] INT NULL,
      [Ratio] DECIMAL(16,2) NULL,
      [Contribution] DECIMAL(16,2) NULL,
      [ChildPartTargetWeight] NUMERIC(18,2) NULL,
      [ChildPartWeight] NUMERIC(18,2) NULL,
          CONSTRAINT [FK_tblKppHierarchyPcl_tblCostMaturity] FOREIGN KEY (CostMaturityID) 
            REFERENCES    tblCostMaturity([CostMaturityID]) 
  )
  </code></pre>
  
  <p>Using a Script.PostDeployment1.sql file, I am trying to populate the table with test data like so: </p>
  
  <pre><code>INSERT INTO [dbo].[tblKppHierarchyPcl]
         ([ID]
         ,[Name]
         ,[PartStructureKey]
         ,[PartNumber]
         ,[ParentPartNumber]
         ,[TargetCost]
         ,[UnitCost]
         ,[CostMaturityID]
         ,[Ratio]
         ,[Contribution]
         ,[ChildPartTargetWeight]
         ,[ChildPartWeight]) VALUES
  (61090,'Coolant Quick Disconnect',125216,'FS-252-6FO','H432677DB-1',27.03,70.61,2,2.61,0.01,0,NULL)
  </code></pre>
  
  <p>I am trying to push the data to the database via SqlPublish.</p>
  
  <p>My problem is this: When the post-deployment script tries to insert the data, I get the following error:</p>
  
  <pre><code>Error SQL72014: .Net SqlClient Data Provider: Msg 245, Level 16, State 1, Line 76 Conversion 
  failed when converting the varchar value 'Coolant Quick Disconnect' to data type int.
  </code></pre>
  
  <p>So it has a problem with inserting 'Coolant Quick Disconnect' into the Name column. The Name column is CLEARLY a varchar column but somehow it thinks it's an int column. </p>
  
  <p>Any ideas?</p>
  
  <p>EDIT: I am using SQL Server 2012. There are no triggers on this table. </p>