Not too familiar with dtsx packages - can they be created/run outisde Visual Studio?
不太熟悉dtsx软件包 - 它们可以在Visual Studio中创建/运行吗?
Is BIDS (Business Intelligence Development Studio) just required to do all the above (in Visual Studio) or is it an independent development enviroment for dtsx packages?
BIDS(商业智能开发工作室)是否只需要完成上述所有工作(在Visual Studio中),还是dtsx软件包的独立开发环境?
Please shed some light if you can (and get some eazy rep)!
如果可以的话,请详细说明(并获得一些eazy rep)!
2 个解决方案
#1
Absolutely! Just double click on it (launches dtexecui.exe) or use the dtexec command. See how all the ways stack up here.
绝对!只需双击它(启动dtexecui.exe)或使用dtexec命令。看看这里的所有方式如何叠加。
Answering some of the other questions:
回答其他一些问题:
BIDS is the sole environment to build SSIS packages. You could handwrite the XML, but good luck to you on that one. BIDS is a standalone product as well as an integrated one, so just install it off of the SQL Server DVD. You will not have to buy Visual Studio in order to use BIDS.
BIDS是构建SSIS包的唯一环境。你可以手写XML,但祝你好运。 BIDS是一个独立的产品,也是一个集成的产品,所以只需将它安装在SQL Server DVD上即可。您不必购买Visual Studio即可使用BIDS。
#2
Visual Studio is based on sets of functionality in Visual Studio "packages" (vspackages). BIDS is just Visual Studio with the vspackages for SSIS, SSRS, and SSAS development. Those same vspackages can be used through "normal" Visual Studio if you already have that installed.
Visual Studio基于Visual Studio“包”(vspackages)中的一组功能。 BIDS只是Visual Studio,带有用于SSIS,SSRS和SSAS开发的vspackages。如果已经安装了那些相同的vspackage,可以通过“普通”Visual Studio使用。
If you don't have Visual Studio installed, then installing BIDS installs it.
如果您没有安装Visual Studio,则安装BIDS会安装它。
Although you can run SSIS packages outside of VS, there's little you can do to debug them that way. It is not practical to create them outside of VS.
虽然您可以在VS之外运行SSIS包,但您无法通过这种方式调试它们。在VS之外创建它们是不切实际的。
Is there a reason you want to do this?
你有没有理由这样做?
Yes, you can get rid of VS2005 as far as BIDS is concerned. Install Visual Studio 2008 SP1, then install the SQL Server 2008 bits you need, including BIDS 2008.
是的,就BIDS而言,你可以摆脱VS2005。安装Visual Studio 2008 SP1,然后安装所需的SQL Server 2008位,包括BIDS 2008。
If you still need to work with SQL Server 2005 SSIS packages, then you still need VS2005 to work with them.
如果您仍然需要使用SQL Server 2005 SSIS包,那么您仍然需要VS2005来使用它们。
#1
Absolutely! Just double click on it (launches dtexecui.exe) or use the dtexec command. See how all the ways stack up here.
绝对!只需双击它(启动dtexecui.exe)或使用dtexec命令。看看这里的所有方式如何叠加。
Answering some of the other questions:
回答其他一些问题:
BIDS is the sole environment to build SSIS packages. You could handwrite the XML, but good luck to you on that one. BIDS is a standalone product as well as an integrated one, so just install it off of the SQL Server DVD. You will not have to buy Visual Studio in order to use BIDS.
BIDS是构建SSIS包的唯一环境。你可以手写XML,但祝你好运。 BIDS是一个独立的产品,也是一个集成的产品,所以只需将它安装在SQL Server DVD上即可。您不必购买Visual Studio即可使用BIDS。
#2
Visual Studio is based on sets of functionality in Visual Studio "packages" (vspackages). BIDS is just Visual Studio with the vspackages for SSIS, SSRS, and SSAS development. Those same vspackages can be used through "normal" Visual Studio if you already have that installed.
Visual Studio基于Visual Studio“包”(vspackages)中的一组功能。 BIDS只是Visual Studio,带有用于SSIS,SSRS和SSAS开发的vspackages。如果已经安装了那些相同的vspackage,可以通过“普通”Visual Studio使用。
If you don't have Visual Studio installed, then installing BIDS installs it.
如果您没有安装Visual Studio,则安装BIDS会安装它。
Although you can run SSIS packages outside of VS, there's little you can do to debug them that way. It is not practical to create them outside of VS.
虽然您可以在VS之外运行SSIS包,但您无法通过这种方式调试它们。在VS之外创建它们是不切实际的。
Is there a reason you want to do this?
你有没有理由这样做?
Yes, you can get rid of VS2005 as far as BIDS is concerned. Install Visual Studio 2008 SP1, then install the SQL Server 2008 bits you need, including BIDS 2008.
是的,就BIDS而言,你可以摆脱VS2005。安装Visual Studio 2008 SP1,然后安装所需的SQL Server 2008位,包括BIDS 2008。
If you still need to work with SQL Server 2005 SSIS packages, then you still need VS2005 to work with them.
如果您仍然需要使用SQL Server 2005 SSIS包,那么您仍然需要VS2005来使用它们。