<div>
Appreciate your comment. &nbsp;Is there anyway to automate the importing of XLS files (About 60 a month) using SSIS?
</div>


Appreciate your comment.  Is there anyway to automate the importing of XLS files (About 60 a month) using SSIS?

<div>
Almost certainly, but it's mostly a SQL Server/SSIS question. Unfortunately, I haven't worked with SSIS much. So I think you're better off getting advice from one of the SQL Server gurus on the exact setup and configuration.
</div>


Almost certainly, but it's mostly a SQL Server/SSIS question. Unfortunately, I haven't worked with SSIS much. So I think you're better off getting advice from one of the SQL Server gurus on the exact setup and configuration.

<div>
<div class="content wysiwyg-content">
I have several large (300,000 rows) xls files to import on a regular basis into SQL. &nbsp;I would like to use ColdFusion to accomplish this unless there is a better way.
</div>
</div>


I have several large (300,000 rows) xls files to import on a regular basis into SQL.  I would like to use ColdFusion to accomplish this unless there is a better way.

ColdFusion - Import large XLS files

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.