22,209
社区成员
发帖
与我相关
我的任务
分享如何将单个SSIS包部署到服务器(高手请进)
各位高手:
最近做SSIS包,只能用SQL Server Business Intelligence Development Studio提供的部署工具,但这个工具是将整个SSIS项部置到服务器上,当我只想部署单个SSIS包时,不知这个该怎么做!请各位告诉如何单个部署SSIS包!
最近做SSIS包,只能用SQL Server Business Intelligence Development Studio提供的部署工具,但这个工具是将整个SSIS项部置到服务器上,当我只想部署单个SSIS包时,不知这个该怎么做!请各位告诉如何单个部署SSIS包!
...全文
请发表友善的回复…
发表回复
shshjun 2011-12-13
- 打赏
- 举报
这个可以从服务器图形导入，也可以用命令行导入部署：
dtutil /DestS . /FILE "MySSIS.dtsx" /COPY SQL;"\MyProj\MySSIS" /Q
更多选择请查看dtutil的文档。
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基本相同.
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
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包!
请高手进来,告诉我!
我问的是:如何将本机上做的好的SSIS包单个发布到服务器上,这样不需要将整个SSIS项目发布到服务上!也会避免影响到其它的SSIS包!
请高手进来,告诉我!
tom_cat007 2007-08-08
- 打赏
- 举报
1. 打开Management Studio 连接数据库 打开SqlServer 代理
2. 选择作业，新建作业
3. 选择步骤，新建
4. 在弹出窗口中类型选择 SSIS 包, 指定包的各种信息，包可以是数据库中的也可以是dtsx文件
5. 如果这个包是单独执行的，可以定计划，否则建议做一个维护计划，调多个作业
2. 选择作业，新建作业
3. 选择步骤，新建
4. 在弹出窗口中类型选择 SSIS 包, 指定包的各种信息，包可以是数据库中的也可以是dtsx文件
5. 如果这个包是单独执行的，可以定计划，否则建议做一个维护计划，调多个作业
香椿炒鸡蛋 2007-08-07
- 打赏
- 举报
关注。。。 写配置文件不知道可不可以
