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.
精彩评论