Databases
StackOverflow2013
Postsdbo
POHow to programmatically create MS Access table in SQL Server using SSIS?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to programmatically create MS Access table in SQL Server using SSIS?
    text
    copied!<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>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload