如何将单个SSIS包部署到服务器(高手请进)

2007-08-06 10:19:56 2.5k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Django网络安全科普学习系统：毕设项目实战与源码解析 Web开发框架是构建现代网络应用的核心工具，其中Django以其高效、安全的特性成为Python开发者的首选。其MTV架构和ORM机制不仅提升了开发效率，更在数据库操作层面通过参数化查询等原理，为应用安全提供了基础保障。在网络安全领域，理解并防范SQL注入、XSS等常见漏洞是开发者的必备技能，这些安全技术的价值在于保护用户数据和系统完整性。将Django框架与网络安全知识结合，构建一个集知识科普、漏洞演示与防御实践于一体的学习系统，成为极具价值的工程实践项目。本文聚焦的Django网络安全科普学习系统，正是阅读详情

各位高手:
最近做SSIS包,只能用SQL Server Business Intelligence Development Studio提供的部署工具,但这个工具是将整个SSIS项部置到服务器上,当我只想部署单个SSIS包时,不知这个该怎么做!请各位告诉如何单个部署SSIS包!

...全文

易灵思Ti60F100 FPGA的HyperRAM实战：从硬件连接到Native接口时序调试本文详细介绍了易灵思Ti60F100 FPGA内置HyperRAM控制器的实战应用。文章从硬件设计要点（如400MHz+信号完整性、等长匹配）切入，重点解析了如何通过Interface Designer配置高效的Native接口，并分享了其时序详解与调试技巧，为开发者提供了一份从硬件连接到软件调试的深度指南。阅读详情

fengglory

疑难问题 22,298 成员 121,727 内容

+ 关注 + 加入社区

切换为时间正序

shshjun 2011-12-13

打赏
举报

这个可以从服务器图形导入，也可以用命令行导入部署：
dtutil /DestS . /FILE "MySSIS.dtsx" /COPY SQL;"\MyProj\MySSIS" /Q

更多选择请查看dtutil的文档。

adandelion 2011-12-13

打赏
举报

guanzhu

90后小朋友 2011-12-13

打赏
举报

学习一下很好的问题

唐诗三百首 2011-11-07

打赏
举报

1.ssis项目执行成功后,在其项目bin目录下,会有一个.dtsx的文件.

2.拷贝此文件到服务器上,新建sql job,新建job step,
类别选择ssis包,然后定位到复制上去的那个.dtsx文件.

3.sql job其实设置与普通job基本相同.

wanglingzhong 2011-11-07

打赏
举报

呃，不知你部署到服务器是文件系统还是SQL Server
单个部署的话，可以将原来的删除然后重新导入包啊

bruli 2010-11-12

打赏
举报

Deploy SSIS Packages
This feature lets you quickly deploy SSIS packages directly from BIDS without having to create a deployment manifest and use the Package Installation Wizard.

First, right click on the project node in Solution Explorer and choose Properties.

BIDS Helper adds a custom tab to the screen that pops up. Flip to the "Deploy (BIDS Helper)" tab and edit the properties to specify how you want to deploy your solution.

The following types of deployment mechanisms are supported:
Simple File Copy - Copies packages to any windows directory.
SQL Server Destination - Copies packages into MSDB in the specified SQL Server instance.
SSIS Package Store (File System) - Copies packages into the SSIS Package Store on the file system of the specified server. (The files end up in "C:\Program Files\Microsoft SQL Server\90\DTS\Packages" by default.)
SSIS Package Store (MSDB) - Copies packages into the SSIS Package Store in MSDB on the specified server.

It is recommended that you click the Configuration Manager button in this dialog and create one Visual Studio configuration per deploy destination (i.e. Development, Staging, Production). BIDS Helper allows you to save separate deployment destination settings per Visual Studio configuration.

When you click the OK button, your BIDS Helper settings for Deploying SSIS Packages are saved into a file in the project directory called <ProjectName>.dtproj.bidsHelper.user.

Next, deploy packages by right clicking on the packages you wish to deploy in Solution Explorer and choosing Deploy. You may right click on a single package, you may Ctrl-click multiple packages then right click on them, or you may right click on the project node to deploy all packages in the project. If you have multiple projects in the solution, all of which are SSIS projects, you can right click on the solution node and deploy all packages from all projects using that menu option.

The Output window displays details about the progress of your deployment:

If deploying an entire project (via the project node menu or the solution node menu), a file is created in the OutputPath (usually the bin directory) called bidsHelperDeployPackages.bat which contains all the commands which were just used to deploy the packages. This bat file can be used as a starter for automating deployment.

Limitations:
SSIS Package Configurations are not deployed. No dtsConfig files can be deployed using BIDS Helper. BIDS Helper will not alter your packages or modify your package configurations. Package configurations should be manually setup on the destination environment before deploying your packages.
Only Windows Integrated Security is supported for deploying packages to SQL Server or the SSIS Package Store.
Packages encrypted with a password are not supported with the Deploy Packages feature unless you set DeploymentType=FilePathDestination (which is just a simple file copy that does not use dtutil and thus does not need to decrypt the package).
If you have customized your MsDtsSrvr.ini.xml, BIDS Helper does not account for this when deploying packages. Please follow and vote for issues SSIS Package Database Name and SSIS 2005 File System package store deployment if this impacts you.

Last edited May 26 at 3:48 AM by furmangg, version 6

bruli 2010-11-12

打赏
举报

这有一个第三方工具，可以提供这样的功能

bruli 2010-11-12

打赏
举报

http://bidshelper.codeplex.com/wikipage?title=Deploy%20SSIS%20Packages&referringTitle=Home&ProjectName=bidshelper

fengglory 2007-08-08

打赏
举报

tom_cat007(猫)说的,应该是行不通的!你只是讲了如何在JOB中加载SSIS包,这个我知道!
我问的是:如何将本机上做的好的SSIS包单个发布到服务器上,这样不需要将整个SSIS项目发布到服务上!也会避免影响到其它的SSIS包!
请高手进来,告诉我!

tom_cat007 2007-08-08

打赏
举报

1. 打开Management Studio 连接数据库打开SqlServer 代理
2. 选择作业，新建作业
3. 选择步骤，新建
4. 在弹出窗口中类型选择 SSIS 包, 指定包的各种信息，包可以是数据库中的也可以是dtsx文件
5. 如果这个包是单独执行的，可以定计划，否则建议做一个维护计划，调多个作业

香椿炒鸡蛋 2007-08-07

打赏
举报

关注。。。写配置文件不知道可不可以

如何将单个SSIS包部署到服务器(高手请进)

相关推荐