摘要: question: i develop a class to write logs. it writes with "StreamWriter.WriteLine()" function. logStream.WriteLine(msgWrite); logStream.Flush(); some 阅读全文
posted @ 2020-07-10 10:15 Javi 阅读(177) 评论(0) 推荐(0) 编辑
摘要: Getting started Step 1 - In this example, we are going to create a package programmatically and copy a file from a source to a destination folder. To 阅读全文
posted @ 2020-07-10 09:36 Javi 阅读(289) 评论(0) 推荐(0) 编辑
摘要: Problem I would like to learn how to fire events, execute T-SQL commands and run SMO with the SQL Server Integration Services (SSIS) Script Task. Can 阅读全文
posted @ 2020-07-10 09:34 Javi 阅读(374) 评论(0) 推荐(0) 编辑
摘要: Problem The SSIS Script Task allows you to add functionality to your SSIS package that does not already exist with the other predefined tasks. In this 阅读全文
posted @ 2020-07-10 09:32 Javi 阅读(394) 评论(0) 推荐(0) 编辑
摘要: 问题 完全监视SQL Server及其相关环境非常麻烦。该 SolarWinds的服务器和应用程序监视器(也称为SAM)提供了一个一站式的方法来轻松,无缝地实现顶级的监测和报告系统,为您的SQL Server。SAM应用程序不仅限于SQL Server,但对于本技巧,重点将放在SQL Server产 阅读全文
posted @ 2020-07-10 09:26 Javi 阅读(517) 评论(0) 推荐(0) 编辑
摘要: 问题 SQL Server Integration Services是Microsoft强大的平台,用于实施提取,转换和加载(ETL)解决方案。它允许SQL Server专业人士解决复杂的商业智能任务,并使用各种数据源。Microsoft提供了用于设计和开发Integration Services项 阅读全文
posted @ 2020-07-10 09:19 Javi 阅读(11293) 评论(0) 推荐(2) 编辑