I have updated the package in BIDS 2005 (I changed the backup routine to save to a different drive) and now I'm trying to get it back on the server (2005). I tried File > Save Copy As... Then ran the job that executes the package and it's still saving to the old drive, thus, my package didn't get saved.
我已经更新了BIDS 2005中的软件包(我更改了备份例程以保存到不同的驱动器),现在我正在尝试将其恢复到服务器上(2005)。我尝试了File> Save Copy As ...然后运行执行包的作业,它仍然保存到旧驱动器,因此,我的包没有得到保存。
2 个解决方案
#1
2
In my opinion always create a deployment utility with your SSIS Project. This is configured under the Project Properties (see below). Once you have configured the project deployment utility, go to your project, find the "bin" folder and double-click the deployment utility. I will walk you through getting your package(s) onto the server really easily.
在我看来,总是使用您的SSIS项目创建一个部署实用程序。这是在项目属性下配置的(见下文)。配置项目部署实用程序后,转到项目,找到“bin”文件夹,然后双击部署实用程序。我将引导您将包裹放到服务器上非常容易。
Good Luck!
#2
1
The quick and dirty answer is to use dtutil
快速而肮脏的答案是使用dtutil
dtutil /file C:\Src\MyPackage.dtsx /destserver thatDatabase /COPY SQL;MyPackage
I too am a fan of the manifest files but, while probably overkill for your problem, I prefer to use tools that allow for unattended use. I combine the ssisdeploymanifest with a PowerShell script to handle all of SSIS deployments.
我也是清单文件的粉丝,但是,尽管你的问题可能有些过分,但我更喜欢使用允许无人值守使用的工具。我将ssisdeploymanifest与PowerShell脚本结合起来处理所有SSIS部署。
Powershell SSIS Deployment and maintenance
Powershell SSIS部署和维护
#1
2
In my opinion always create a deployment utility with your SSIS Project. This is configured under the Project Properties (see below). Once you have configured the project deployment utility, go to your project, find the "bin" folder and double-click the deployment utility. I will walk you through getting your package(s) onto the server really easily.
在我看来,总是使用您的SSIS项目创建一个部署实用程序。这是在项目属性下配置的(见下文)。配置项目部署实用程序后,转到项目,找到“bin”文件夹,然后双击部署实用程序。我将引导您将包裹放到服务器上非常容易。
Good Luck!
#2
1
The quick and dirty answer is to use dtutil
快速而肮脏的答案是使用dtutil
dtutil /file C:\Src\MyPackage.dtsx /destserver thatDatabase /COPY SQL;MyPackage
I too am a fan of the manifest files but, while probably overkill for your problem, I prefer to use tools that allow for unattended use. I combine the ssisdeploymanifest with a PowerShell script to handle all of SSIS deployments.
我也是清单文件的粉丝,但是,尽管你的问题可能有些过分,但我更喜欢使用允许无人值守使用的工具。我将ssisdeploymanifest与PowerShell脚本结合起来处理所有SSIS部署。
Powershell SSIS Deployment and maintenance
Powershell SSIS部署和维护