开发者

Are there any size limitations in SSIS package files?

I'm currently searching for physical size limitation of a DTSX file. We lose someting proporties, and is seems that it's only appening to quite big DTSX file (+5Mb)

Does anyone have a good link or a开发者_运维百科dvise ?


If you are creating a dtsx file whose size grows to 5 MB, I can only imagine that the process flow in the file itself is monstrously large. When SSIS tries to load too many jobs within a single package, it puts strains on the reserved resources for that package. I would recommend breaking your package up into several smaller packages each focused on one particular area of functionality, and creating one master package to launch the sub packages in order.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜