title: How to programmatically create MS Access table in SQL Server using SSIS?
body: <p>I receive monthly data updates for a SQL databse shipped to me in an ACCESS database, there are about 30 tables that follow this pattern the largest table contains approximately 40,000 rows.</p>
  
  <pre><code>CREATE TABLE [dbo].[TABLE_NAME_HERE] (
  [title] nvarchar (255) NULL, 
  [classification1] nvarchar (255) NULL, 
  [classification2] nvarchar (255) NULL, 
  [1986] float NULL, 
  [1987] float NULL, 
  [1988] float NULL, 
  [1989] float NULL, 
  [1990] float NULL, 
  [1991] float NULL, 
  [1992] float NULL, 
  [1993] float NULL, 
  [1994] float NULL, 
  [1995] float NULL, 
  [1996] float NULL, 
  [1997] float NULL, 
  [1998] float NULL, 
  [1999] float NULL, 
  [2000] float NULL, 
  [2001] float NULL, 
  [2002] float NULL, 
  [2003] float NULL, 
  [2004] float NULL, 
  [2005] float NULL, 
  [2006] float NULL, 
  [2007] float NULL, 
  [2008] float NULL, 
  [2009] float NULL, 
  [2010] float NULL, 
  [2011] float NULL, 
  [2012] float NULL, 
  [2013] float NULL, 
  [2014] float NULL, 
  [2015] float NULL, 
  [2016] float NULL, 
  [2017] float NULL, 
  [2018] float NULL, 
  [2019] float NULL, 
  [2020] float NULL, 
  [2021] float NULL, 
  [2022] float NULL, 
  [2023] float NULL, 
  [2024] float NULL, 
  [2025] float NULL)
  </code></pre>
  
  <p>We currently have a DTSX package that uploades these table however every so often (yearly) they add another column, and the DTSX package has the column details harded coded.</p>
  
  <p>We do not have the time or budget to reprogram the applications envolved - though I agree there are many better ways of storing this data.</p>
  
  <p>I would like to have the DTSX package automaticaly DROP the table on the SQL server, CREATE a TABLE that matches the one the ACCESS database and upload the data.</p>
  
  <p>Is this possible?</p>