I have an SSIS package named Extract.dtsx. I want to deploy it to the file system in F:\SQL2005\MSSQL\Package\Extract.
我有一个名为Extract.dtsx的SSIS包。我想将它部署到F:\ SQL2005 \ MSSQL \ Package \ Extract中的文件系统。
The Package Instllation Wizard does this simply. I only have to choose "File system deployment" and choose the path, then click next a few times and finish. I'm having trouble figuring out if I can do the same this using DTUTIL.
Package Instllation Wizard简单地执行此操作。我只需选择“文件系统部署”并选择路径,然后单击下一步并完成。我无法确定是否可以使用DTUTIL执行相同的操作。
Does anybody know if this is possible?
有人知道这是否可行?
1 个解决方案
#1
Yes, it's possible. I'm not sure what I was doing wrong.
是的,这是可能的。我不确定我做错了什么。
If you have an SSIS package C:\temp\Extract.dtsx, you can deploy it to the file system in F:\SQL2005\MSSQL\Package\Extract using these commands:
如果您有一个SSIS包C:\ temp \ Extract.dtsx,则可以使用以下命令将其部署到F:\ SQL2005 \ MSSQL \ Package \ Extract中的文件系统:
c:\temp\md F:\sql2005\mssql\package\Extract
c:\temp\dtutil /file Extract.dtsx /Copy FILE;F:\sql2005\mssql\package\Extract\Extract.dtsx
The destination folder must already exist.
目标文件夹必须已存在。
You can see the package in SQL Enterprise Manager by connecting to SSIS on the server, open Stored Packages > SSIS Application Packages > Extract.
您可以通过连接到服务器上的SSIS来查看SQL Enterprise Manager中的包,打开存储包> SSIS应用程序包>提取。
#1
Yes, it's possible. I'm not sure what I was doing wrong.
是的,这是可能的。我不确定我做错了什么。
If you have an SSIS package C:\temp\Extract.dtsx, you can deploy it to the file system in F:\SQL2005\MSSQL\Package\Extract using these commands:
如果您有一个SSIS包C:\ temp \ Extract.dtsx,则可以使用以下命令将其部署到F:\ SQL2005 \ MSSQL \ Package \ Extract中的文件系统:
c:\temp\md F:\sql2005\mssql\package\Extract
c:\temp\dtutil /file Extract.dtsx /Copy FILE;F:\sql2005\mssql\package\Extract\Extract.dtsx
The destination folder must already exist.
目标文件夹必须已存在。
You can see the package in SQL Enterprise Manager by connecting to SSIS on the server, open Stored Packages > SSIS Application Packages > Extract.
您可以通过连接到服务器上的SSIS来查看SQL Enterprise Manager中的包,打开存储包> SSIS应用程序包>提取。