blocks|key|3188954|text|如果单个数据库中可能包含“EventLog”一词的多个表，则需要为父容器内的每个表(每个表)添加一个附加项。使用父容器和当前容器中的变量在其中为每个容器构建一个动态删除语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3188955|您的包应该非常类似于此：|3188956|控制流|offset|length|style|BOLD|3188957|📷|atomic|3188958|​|3188959|包变量|3188960|3188961|将日期筛选器添加到“delete_log_records_sql”变量中|3188962|获取数据库名称-执行SQL+|3188963|3188964|3188965|获取DB名称-将结果分配给对象|3188966|3188967|3188968|Foreach+DB+-+DB名称对象Var映射|3188969|3188970|3188971|Foreach+DB+-+DB名称集合Var映射|3188972|3188973|3188974|获取表名-执行SQL+|3188975|3188976|3188977|获取表名-将结果分配给对象|3188978|3188979|3188980|Foreach表-表名对象Var映射|3188981|3188982|3188983|Foreach表-表名集合Var映射|3188984|3188985|3188986|删除日志记录-执行SQL+|3188987|3188988|3188989|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/5411491a4806319f2eb3f2b6d086f45c.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/49ed85f796b05151e4e6478a74e92740.png|2|https://developer.qcloudimg.com/http-save/yehe-900000/e25bff3fa55a937bda4c2d1eaee7dbce.png|3|https://developer.qcloudimg.com/http-save/yehe-900000/83e514d8555dea5bf3aef49b680735d8.png|4|https://developer.qcloudimg.com/http-save/yehe-900000/a7b45631316c3fad90ede500aaa61ef2.png|5|https://developer.qcloudimg.com/http-save/yehe-900000/62d74eed1b06b3556b7cd80e26053563.png|6|https://developer.qcloudimg.com/http-save/yehe-900000/16c3f6d1ed5c82d2545186b3dc0c6c97.png|7|https://developer.qcloudimg.com/http-save/yehe-900000/1196446364f86d6f1331975362c316e3.png|8|https://developer.qcloudimg.com/http-save/yehe-900000/4a225cf086089f8d2e612599691a9918.png|9|https://developer.qcloudimg.com/http-save/yehe-900000/04a7352889dfc781dc8f6f9ea92291cb.png|10|https://developer.qcloudimg.com/http-save/yehe-900000/b01927229c1e6978d7607b08b7980398.png^0|0|0|0|3|0|0|1|0|0|0|0|3|0|0|1|1|0|0|0|E|0|0|1|2|0|0|0|F|0|0|1|3|0|0|0|O|0|0|1|4|0|0|0|O|0|0|1|5|0|0|0|B|0|0|1|6|0|0|0|D|0|0|1|7|0|0|0|I|0|0|1|8|0|0|0|I|0|0|1|9|0|0|0|D|0|0|1|A|0|0^^$0|@$1|2|3|4|5|6|7|2M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|2O|8|@$F|2P|G|2Q|H|I]]|9|@]|A|$]]|$1|J|3|K|5|L|7|2R|8|@]|9|@$F|2S|G|2T|1|2U]]|A|$]]|$1|M|3|N|5|6|7|2V|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|2W|8|@$F|2X|G|2Y|H|I]]|9|@]|A|$]]|$1|Q|3|K|5|L|7|2Z|8|@]|9|@$F|30|G|31|1|32]]|A|$]]|$1|R|3|S|5|6|7|33|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|34|8|@$F|35|G|36|H|I]]|9|@]|A|$]]|$1|V|3|K|5|L|7|37|8|@]|9|@$F|38|G|39|1|3A]]|A|$]]|$1|W|3|N|5|6|7|3B|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|3C|8|@$F|3D|G|3E|H|I]]|9|@]|A|$]]|$1|Z|3|K|5|L|7|3F|8|@]|9|@$F|3G|G|3H|1|3I]]|A|$]]|$1|10|3|N|5|6|7|3J|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|3K|8|@$F|3L|G|3M|H|I]]|9|@]|A|$]]|$1|13|3|K|5|L|7|3N|8|@]|9|@$F|3O|G|3P|1|3Q]]|A|$]]|$1|14|3|N|5|6|7|3R|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|3S|8|@$F|3T|G|3U|H|I]]|9|@]|A|$]]|$1|17|3|K|5|L|7|3V|8|@]|9|@$F|3W|G|3X|1|3Y]]|A|$]]|$1|18|3|N|5|6|7|3Z|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|40|8|@$F|41|G|42|H|I]]|9|@]|A|$]]|$1|1B|3|K|5|L|7|43|8|@]|9|@$F|44|G|45|1|46]]|A|$]]|$1|1C|3|N|5|6|7|47|8|@]|9|@]|A|$]]|$1|1D|3|1E|5|6|7|48|8|@$F|49|G|4A|H|I]]|9|@]|A|$]]|$1|1F|3|K|5|L|7|4B|8|@]|9|@$F|4C|G|4D|1|4E]]|A|$]]|$1|1G|3|N|5|6|7|4F|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|6|7|4G|8|@$F|4H|G|4I|H|I]]|9|@]|A|$]]|$1|1J|3|K|5|L|7|4J|8|@]|9|@$F|4K|G|4L|1|4M]]|A|$]]|$1|1K|3|N|5|6|7|4N|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|6|7|4O|8|@$F|4P|G|4Q|H|I]]|9|@]|A|$]]|$1|1N|3|K|5|L|7|4R|8|@]|9|@$F|4S|G|4T|1|4U]]|A|$]]|$1|1O|3|N|5|6|7|4V|8|@]|9|@]|A|$]]|$1|1P|3|1Q|5|6|7|4W|8|@$F|4X|G|4Y|H|I]]|9|@]|A|$]]|$1|1R|3|K|5|L|7|4Z|8|@]|9|@$F|50|G|51|1|52]]|A|$]]|$1|1S|3|N|5|6|7|53|8|@]|9|@]|A|$]]|$1|1T|3|-4|5|6|7|54|8|@]|9|@]|A|$]]]|1U|$1V|$5|1W|1X|1Y|A|$1Z|20|21|-4]]|22|$5|1W|1X|1Y|A|$1Z|23|21|-4]]|24|$5|1W|1X|1Y|A|$1Z|25|21|-4]]|26|$5|1W|1X|1Y|A|$1Z|27|21|-4]]|28|$5|1W|1X|1Y|A|$1Z|29|21|-4]]|2A|$5|1W|1X|1Y|A|$1Z|2B|21|-4]]|2C|$5|1W|1X|1Y|A|$1Z|2D|21|-4]]|2E|$5|1W|1X|1Y|A|$1Z|2F|21|-4]]|2G|$5|1W|1X|1Y|A|$1Z|2H|21|-4]]|2I|$5|1W|1X|1Y|A|$1Z|2J|21|-4]]|2K|$5|1W|1X|1Y|A|$1Z|2L|21|-4]]]]

If there are multiple tables that may contain the word 'EventLog' in a single database, you need to add an additional for each (for each table) inside the parent 'for each' container. Build a dynamic delete statement inside this for each container using the variables from the parent and current container. 

Your package should look very similar to this: 

Control Flow
<a href="https://i.stack.imgur.com/JEia4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JEia4.png" alt="enter image description here"></a>

Package Variables
<a href="https://i.stack.imgur.com/neo3V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/neo3V.png" alt="enter image description here"></a>
add your date filter to the 'delete_log_records_sql' variable

Get DB Names - Execute SQL Task
<a href="https://i.stack.imgur.com/aJKpk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aJKpk.png" alt="enter image description here"></a>

Get DB Names - Assign Results to Object Var
<a href="https://i.stack.imgur.com/xI6mY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xI6mY.png" alt="enter image description here"></a>

Foreach DB - DB Name Object Var Mapping
<a href="https://i.stack.imgur.com/ZsBYu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZsBYu.png" alt="enter image description here"></a>

Foreach DB - DB Name Collection Var Mapping
<a href="https://i.stack.imgur.com/43sKe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/43sKe.png" alt="enter image description here"></a>

Get Table Names - Execute SQL Task
<a href="https://i.stack.imgur.com/wZn9e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wZn9e.png" alt="enter image description here"></a>

Get Table Names - Assign Results to Object Var
<a href="https://i.stack.imgur.com/H68uO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H68uO.png" alt="enter image description here"></a>

Foreach Table - Table Name Object Var Mapping
<a href="https://i.stack.imgur.com/gFw9a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gFw9a.png" alt="enter image description here"></a>

Foreach Table - Table Name Collection Var Mapping
<a href="https://i.stack.imgur.com/Xixl0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Xixl0.png" alt="enter image description here"></a>

Delete Log Records - Execute SQL Task
<a href="https://i.stack.imgur.com/hIml7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hIml7.png" alt="enter image description here"></a>

I need help in creating a package that iterates through databases in a given server, looks for a table name that contains the word 'EventLog' and delete all rows older than a year. The deletion should be in batch of 50000. 

I was able to read the database names using Execute SQL task, stored the full result set in a object type variable and used for each loop container to read the results from the variable and need help from there

SSIS package to loop through databases to find a table and delete older rows

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

在创建一个包时，我需要帮助，它可以遍历给定服务器中的数据库，查找包含单词“EventLog”的表名，并删除超过一年的所有行。删除应批次为50000。我能够使用Execute SQL任务读取数据库名称，将完整的结果集存储在一个对象类型变量中，并用于每个循环容器来读取变量的结果，并需要那里的帮助。

问通过数据库循环查找表和删除旧行的SSIS包
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过数据库循环查找表和删除旧行的SSIS包EN