SSIS

  • 网络SQL Server Integrated Services; 集成服务(SQL Server Integration Services)

SSISSSIS

SSIS

SQL Server Integrated Services

  SQL Server Integrated Services(SSIS)平台下,通常一个package运行失败后,经过失败原因的检查和处理,会从头到尾完 整 …

集成服务(SQL Server Integration Services)

使用集成服务SSIS); 使用SQL Server导入和导出向导创建包; 使用BCP导入、导出数据; 使用BULK INSERT 命令。

1
And navigation is usually common, so maybe SSIs work for that, as well. 导航通常也是通用的,所以SSI也可能适用。
2
The mark option above prevents any changing to those who ask to found a watch afresh is in in SSIS when the examination. 上面的标记选项在检查时防止在SSIS中要求重新创建表的任何更改。
3
When a package is saved, SSIS Designer saves the grouping, but the grouping has no effect on package execution. 保存包时,SSIS设计器也保存分组,但是分组对包的执行没有影响。
4
The SSIS Designer provides annotations , which you can use to make packages self- documenting and easier to understand and maintain . SSIS设计器提供批注,利用它们可使包自文档化,更易理解和维护。
5
To open SSIS Designer, you double-click a package in the SSIS Packages folder in an Integration Services project. 若要打开SSIS设计器,请双击IntegrationServices项目中“SSIS包”文件夹中的包。
6
The name provided will be displayed within the Connection Managers area of SSIS Designer. 所提供的名称将显示在SSIS设计器的“连接管理器”区域中。
7
Microsoft SQL Server 2005 Integration Services (SSIS) provides tools that make it easy to deploy packages to another computer. MicrosoftSQLServer2005IntegrationServices(SSIS)提供了将包轻松部署到其他计算机的工具。
8
Note that SSIS reserves the right to revise our Fee Schedule due to the fluctuation in currency exchange. 备注:由于外汇兑换率的起伏较大,我校将对任何学费变更保留最终解释权。
9
The warning does not appear when you reopen the package in SSIS Designer, if you have run the package at least one time. 运行包至少一次之后在SSIS设计器中重新打开包时,将不会显示该警告。
10
Contains procedures for enabling logging for SSIS packages, for selecting log providers, and for choosing the information to log. 包含对SSIS包启用日志记录的过程,选择日志提供程序的过程,以及选择要记入日志的信息的过程。
11
Integration Services provides containers, tasks, and transformations for building business intelligence into SSIS packages. IntegrationServices提供了用于将商业智能置入SSIS包的容器、任务和转换。
12
The expression must be a valid expression that uses the SSIS expression grammar syntax. 表达式必须是使用SSIS表达式语法的有效表达式。
13
These tasks are commonly used in database maintenance plans, but the tasks can also be included in SSIS packages. 这些任务通常用于数据库维护计划中,但也可以包含在SSIS包中。
14
If you run a package in SSIS Designer, you can view the data in a data flow by attaching data viewers to a path. 如果在SSIS设计器中运行包,您可以将数据查看器附加到一个路径,以此来查看数据流中的数据。
15
SSIS Designer graphically implements the SSIS object model, letting you create packages that perform a wide range of functions. SSIS设计器以图形方式实现SSIS对象模型,使您可以创建执行各种函数的包。
16
SQL Server 2005 Integration Services (SSIS) does not support the delegation of credentials, sometimes referred to as a double hop. SQLServer2005IntegrationServices(SSIS)不支持委托凭据(有时也称为双跃点)。
17
ISNULL accepts an expression of any SSIS data type and returns a Boolean (DT_BOOL) result. ISNULL接受任意SSIS数据类型的表达式,并返回一个布尔值(DT_BOOL)结果。
18
The expression can include the variables, literals, and any operators and functions that the SSIS expression grammar supports. 表达式可以包含SSIS表达式语法支持的变量、文字以及任何运算符和函数。
19
A path annotation displays the name of the path source or the path name on the design surface of the Data Flow tab in SSIS Designer. 路径批注显示路径源的名称或SSIS设计器中“数据流”选项卡的设计图面上的路径名称。
20
This option specifies that the SSIS package to be operated on is located in the file system. 此选项指定要操作的SSIS包位于文件系统中。
21
Each source server ran SSIS packages that sent data across the network to the database server. 每一个源服务器运行一个SSIS包将数据通过网络发送到数据库服务器上。
22
Saved packages can be opened in Business Intelligence Development Studio and extended by using SSIS Designer. 已保存的包可以在BusinessIntelligenceDevelopmentStudio中打开,并且可以使用SSIS设计器进行扩展。
23
You can review the saved version of the package created by this code sample by opening the package in SSIS Designer. 您可以通过在SSIS设计器中打开包来查看由此代码示例创建的持久化版本的包。
24
The service must be running to monitor the packages that are stored in the SSIS Package Store. 该服务必须运行,才能监视存储在SSIS包存储区中的包。
25
SSIS Designer includes annotations that you can add to a data flow. SSIS设计器包含可以添加到数据流的批注。
26
When you first add a project to a solution, SSIS automatically adds an empty package to the project. 当首次向解决方案中添加项目时,SSIS会自动向项目添加一个空包。
27
What follows is a summary of the Jamie Tomson's experience using SSIS in a team setting. 如下是JamieTomson在团队环境中使用SSIS的一个经验总结。
28
The package must be opened in SSIS Designer before you can save a copy of the package. 在保存包的副本之前,必须在SSIS设计器中打开包。
29
The name provided will be displayed within SSIS Designer. 所提供的名称将在SSIS设计器中显示。
30
This task is in the Maintenance Plan Tasks section of the Toolbox in SSIS Designer. 此任务位于SSIS设计器中“工具箱”的“维护计划中的任务”部分。