使用SSIS将Access DB传输到SQL Server DB
问题描述：
如何使用SQL Server Integration Services将完整的数据库从Access传输到SQL Server 2012？
How can I transfer a full database from Access to SQL Server 2012 using SQL Server Integration Services?
答
另一种解决方案是使用导入/导出向导。只需右键单击SQL Server中的数据库，然后选择任务>导入数据。该向导将引导您完成设置。最后，您可以保存该软件包，然后可以在BIDS中对其进行编辑。
Another solution is to use the Import/Export wizard. Simply right click on a database in SQL Server, choose Tasks > Import Data. The wizard will walk you through the setup. At the end you can save the package which then can be edited in BIDS.