SSIS
dbLenis
Even the longest journey begins with a single step
展开
-
简单SSIS运用
SSIS最大的优点是对各个ETL节点的监控性能很强,只要出错,马上就可以看到是哪个节点出问题了,这一点在使用中非常直观原创 2008-11-09 11:39:00 · 1909 阅读 · 1 评论 -
PipeLineExecutionPlan in SSIS 2008
默认情况下,在ssis中task的logmode默认是UseParentSetting,所以在package的"Configure SSIS Logs" 窗口中,是不能为data flow task指定为"PipeLineExecutionPlan" 和"PipeLineExecutionTrees"的events的。要实现为这两个event提供Logging,需要把data flow task的原创 2012-06-17 00:25:55 · 1041 阅读 · 0 评论 -
cannot generate SSPI context
在设计SSIS 的时候,debug的时候,发现:[Connection manager "Sandbox.OLEDB"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source:原创 2012-04-18 00:30:42 · 1802 阅读 · 0 评论 -
Null value is eliminated by an aggregate or other SET operation and returned error code 0xC0202009
[OE Source [791]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" H翻译 2012-04-05 23:27:18 · 3508 阅读 · 0 评论 -
.dtproj .dtproj.vspscc .vssscc
Files used by source control integration in VSS and VS .NET There are a couple of files used by VisualStudio and SourceSafe for source control integration.Before describing what is stored in t转载 2012-03-18 00:07:41 · 2521 阅读 · 0 评论 -
减少SSIS包Validation的时间 - reduce SSIS package validation time
SSIS包打开的时候,会进行Validation, 有时候会执行太长时间。通过将包设置为work offline可以有效减少validation的等待时间看看老外是怎么说的:http://beyondrelational.com/blogs/community/archive/2011/07/13/ssis-package-taking-forever-to-loa翻译 2012-02-19 22:56:54 · 1066 阅读 · 0 评论 -
SSIS Additional Components Projects
Are you really crazy at SSIS ?Get most out of the following Website: http://ssisctc.codeplex.com/翻译 2012-02-26 22:41:18 · 556 阅读 · 0 评论 -
SQL SERVER SERVICE BROKER - QUEUE Retention
在创建QUEUE的时候,指定retention也很重要。。1. 如果retention=on.那么即使message被receive之后,还是留在了queue里面,直到这个conversation被endALTER QUEUE [dbo].[targetQueue] WITH STATUS = ON , RETENTION = ON , POISON_MESSAGE_HANDLIN原创 2012-02-23 22:24:28 · 1245 阅读 · 0 评论 -
Service Broker Simple Example
--select name, database_id, service_broker_guid, is_broker_enabled from sys.databases;--1 one process messages table for storing sending message action-- create table imessages ( Id uniqueidenti原创 2012-02-23 00:18:14 · 832 阅读 · 1 评论 -
SSIS - NoMatchBehavior Error fail Component
在SSIS中,使用lookup transformation时候,如果将“NoMatchBehavior"设置成为”Treat rows with no matching entries as errors.“,那么会导致使得整个task fail的情况,如果将这个属性设置为”Send rows with no matching entries to the no match output.“则不原创 2012-02-23 00:27:55 · 1756 阅读 · 0 评论 -
SSIS - Precedence Constraints
The green arrow represents On Success and means that the second (or downstream) task will only execute if the first (or upstream) task or set of tasks executes successfully.--绿色箭头代表当上一任务成功后,执行一下任务翻译 2011-11-21 21:25:30 · 1329 阅读 · 0 评论 -
SQL SERVER -SCD Solution
看下SQL SERVER中,对SCD的解决方案(不看SQL SERVER 2008 CDC方法),摘自《expert sql server 2005 integration services》在这里介绍的SCD TYPE0,1,2与KIM BALL的(TYPE1,TYPE2,转载 2011-10-10 23:18:05 · 1958 阅读 · 0 评论 -
Programming on SSIS - 自定义编程 ( 一 )
custom programming on ssis packages原创 2015-05-12 20:36:14 · 1077 阅读 · 0 评论