SSIS - CUSTOM LOGGING STEPS

Event Handlers And Custom Logging - SSIS PART 2

SSIS - CUSTOM LOGGING STEPS

Redirecting Error Records During Data Loads - SSIS

Event Handlers And Custom Logging - SSIS PART 1

























































Event Handler:


Like the Try And Catch.

In the below it shows in event handler the two things

In Executable , u can "perform" or  "CATCH".

Currently we do not have any "executable".

Event Handler at the package level.

If we create a sql task ,under the executable show the task , log at the task level and

not at the package level.

variables mapped:

Get the job run id and get the next one and through out the job run the job run id remains same.

set flag

This variable is set on all the events.

Configure a Report Portal in SSRS

How to turn IDENTITY_INSERT on and off using SQL Server 2008?

Enterprise Data Warehouse Bus Matrix

conformed dimension

Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.

Single Front-end for multiple SSRS/SQL instances

---

Fact table consists of the measurements, metrics or facts of a business process. 

--

Choosing a Primary Key: Natural or Surrogate?

• Key. A key is one or more data attributes that uniquely identify an entity.  In a physical database a key would be formed of one or more table columns whose value(s) uniquely identifies a row within a relational table. 
• Composite key. A key that is composed of two or more attributes. 
• Natural key. A key that is formed of attributes that already exist in the real world.  For example, U.S. citizens are issued a Social Security Number (SSN)  that is unique to them (this isn't guaranteed to be true, but it's pretty darn close in practice).  SSN could be used as a natural key, assuming privacy laws allow it, for a Person entity (assuming the scope of your organization is limited to the U.S.). 
• Surrogate key. A key with no business meaning.
• Candidate key. An entity type in a logical data model will have zero or more candidate keys, also referred to simply as unique identifiers (note: some people don't believe in identifying candidate keys in LDMs, so there's no hard and fast rules). For example, if we only interact with American citizens then SSN is one candidate key for the Person entity type and the combination of name and phone number (assuming the combination is unique) is potentially a second candidate key. Both of these keys are called candidate keys because they are candidates to be chosen as the primary key, an alternate key or perhaps not even a key at all within a physical data model. 
• Primary key. The preferred key for an entity type.
• Alternate key. Also known as a secondary key, is another unique identifier of a row within a table. 
• Foreign key. One or more attributes in an entity type that represents a key, either primary or secondary, in another entity type.

- See more at: http://www.agiledata.org/essays/keys.html#sthash.voaMLW8f.dpuf

---

How to deploy ssrs report on production server

Porting SSRS reports from Dev to Production Server

Reset Identity Column Value in SQL Server

How to Configure Report Subscriptions in SQL Reporting Services

SQL SERVER – Create a Very First Report with the Report Wizard

How to Setup an Email Subscription in SSRS

SQL - Rounding off to 2 decimal places

select cast((630/60.0) as  decimal(16,2))