开发者

Are there any size limitations in SSIS package files?

开发者 https://www.devze.com 2022-12-29 15:43 出处:网络
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)

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

精彩评论

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