SQL Server Management Studio 2008计划导出到MS Access [英] SQL Server Management Studio 2008 scheduled export to MS Access

问题描述

专家!!

我不熟悉SQL Server Management Studio，从来没有必要在SQL Server上安排任务。

我每天将我的数据库导出到MS Access。我需要管理工作室每天凌晨2:00自动执行此操作。

任何想法。

解决方案

在用于导出数据的向导屏幕上，选择保存SSIS包选项，下一个屏幕将为您提供保存该包的选项。然后转到SQL Server代理并安排该软件包

右键单击作业并选择新作业

向作业提供名称和说明 >

>

选择步骤，命名步骤，选择SSIS作为类型，选择包来源，然后选择您的包

计划作业

Experts !!

I am not familiar with SQL Server Management Studio and never had to schedule tasks on an SQL Server.

I am exporting my database to MS Access everyday. I need Management Studio to do this automatically everyday at 2:00 am.

Any ideas.

解决方案

On the wizard screen that you are using to export data, select the Save SSIS Package option, the next screen will give you the options to save that package. Then go to SQL Server Agent and schedule that package

Right click on Jobs and select New Job

Give the Job a name and description

Select Steps, Name the step, select SSIS as the Type, select the Package source and then select your Package

Schedule the job

这篇关于SQL Server Management Studio 2008计划导出到MS Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！