SSIS变量4000个字符限制并将其分为两个变量 [英] SSIS variable 4000 character limit and spliting it into two variables

问题描述

有人可以向我解释为什么SSIS 2012中的变量表达式限制为4000个字符吗?如果超过该数量会怎样?

can someone explain to me why the variable expression in SSIS 2012 is at 4000 character limit? What would happen if it does go over that amount?

我了解还有其他方法可以执行此操作，例如使用SP.由于限制为4000个字符，您如何将其分为两个变量?就像将一半放在一个变量中，另一半放在另一个变量中一样.有哪些最佳实践可以做到这一点?

I understand that there are other ways to do this like using a SP. Since it is at 4000 char limit, how can you break it up into two variables? Like put one half in one variable and the other half in the other. What are some best practices to do this?

推荐答案

是.这是一个限制. 为数据流任务创建查询的单独的变量存储部分，然后使用脚本任务在运行时将它们全部组合为最终变量. 请参考此. http://www.texastoo.com/post/2009/07/27/SSIS-workaround-for-the-4000-byte-character-limit.aspx

Yes. It is a limitation. create the separate variables storing sections of your query for the Data Flow Task, and then use the script task to combine them all into a final variable at runtime. Refer this. http://www.texastoo.com/post/2009/07/27/SSIS-workaround-for-the-4000-byte-character-limit.aspx

这篇关于SSIS变量4000个字符限制并将其分为两个变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！