在一项任务中,我可以建立一个表变量表
DELCARE @TableVar TABLE (...)
然后在另一个任务或数据目的地选择或插入表格变量?
我考虑的其他选择是使用一个温度表。
CREATE TABLE #TempTable (...)
我更喜欢使用表Variable,以便保持记忆。 但是,如果无法使用表变量,则可以采用表率。 而且,我无法利用创纪录的目的地,因为我需要在稍后阶段就着手完成它的直接任务。
试图解决这一使用案例,基本上是在BizTalk进行转变。 BizTalk必须改变数据量,否则数据量就会在BizTalk服务器上产生不可接受的负荷,因此,要把数据装上SSIS。 然而,这并不是一个简单的增长,而是有不同类型的增长,彼此关系。 信息社会首脑会议的第一项任务是将该行装成适当的(当时的)表格,然后在第二个数据任务中,选定排出正确的产出格式。
You could use some of the techniques in this post: http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx
especially the ones about using RetainSameConnection=TRUE on the connection manager.
I would be interested to see more information about what use case you have that requires you to write out data to a temp table or table variable before further SSIS processing. Couldn t you take care of all of the SQL required steps in your source query before you start processing the dataflow with SSIS?
表变量并非只保存在记忆中,可按记忆压力书写成磁盘。 我倾向于将表变量用于非常小的眼光。 如果由于必要和复杂的转变,你需要把桌子推到服务器中,那么就使用一个在安装之前在SSIS一揽子计划中的固定温床。 简单明了,并将得到你们所需要的帮助。
信息社会首脑会议一揽子计划将开展工作。 我假定,它的工作范围是空洞。 在该案中,使用一个温带赢得了一定伤害。 页: 1 工作通常在工作时间之后进行,因此无关紧要。
I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...
TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...
I have a stored procedure which takes an XML parameter and inserts the data into multiple tables. If I run the stored procedure into a database using a SSMS query window, everything works fine. ...
Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...
I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...
I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
I m trying to transform the SQL Query below into Linq to SQL select Categorias.IdCategoria, Categorias.Nome, SUM(lancamentos.valor) from lancamentos left outer join Categorias on Lancamentos....