CLARIFIED for Clarizen is going mobile!

Probably you already knew that CLARIFIED for Clarizen is the reporting and analysis service for Clarizen users, offers rich dashboards and enables you to analyze your Clarizen data across all projects, using various criteria. All this within just a few mouse clicks.

But did you know it can be used as a source for bringing your reports and dashboards to your mobile phone or tablet?

We have setup dashboards in RoamBI, a mobile business intelligence solution that transforms data from major BI Systems into dashboard-style mobile analytics for iPhone or iPad, for one of our customers using our CLARIFIED for Clarizen service.

Besides using RoamBI other third party (mobile) BI or reporting solutions can be used to create your own dashboards and make it accessible on any device. Similar to monitoring the financial markets on TV, you now can focus on the Clarizen metrics that matters most to you.

Interested? Please contact me via H.O.Israel@BI-Architects.nl or visit our clarified.biz portal for more information and to start your trial today!

New CLARIFIED for Clarizen product video

Today we have released a new CLARIFIED for Clarizen product video.



Visit our website at www.clarified.biz for more information about CLARIFIED for Clarizen.

Delete duplicates from SQL without having a primary key

Recently I had a problem with finding duplicate records in a SQL table without having a primary key. Because I didn't want to create a primary key in the table, I had to use a different method in my SQL statement.

In the SQL example below you will see how to find the duplicate records. I used the SQL
ROW_NUMBER() function for it to differentiate between duplicate records.

DELETE SubQuery FROM
(SELECT ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID) NumOccurrences
FROM [dbo].[ClarizenDeletions]) SubQuery
WHERE SubQuery.NumOccurrences > 1

CLARIFIED for Clarizen version 1.3 released

With great enthusiasm we introduce version 1.3 of the Analysis and Reporting extension Clarified for Clarizen to you. Working closely with Clarizen, BI Architects we developed this extension for Clarizen customers who require extensive analysis of their Clarizen project data and/or in need of extensive reporting features including dashboards and KPI's.

CLARIFIED for Clarizen enables you to analyze your Clarizen data across all projects, using various criteria from a management point of view (highlights, KPI’s) or with detailed views for specific projects (Trends, Earned value, CPI, SPI, Resource Utilization etc.). All this within just a few mouse clicks. You can think of criteria like: Customers, Employees, Time periods, Project types and Task types.

In the 1.3 version of CLARIFIED for Clarizen we have improved and speed up the process of importing and refreshing  Clarizen data in the backend. In the frontend we have simplified our information model by gathering the date dimensions and adding the measure group Resource Capacity.

If you are interested in using CLARIFIED for Clarizen please visit and register at clarified.biz. After registration you can use the full functionality of Clarified for Clarizen free for 30 days to make sure you like it. We don't ask your for a credit card when you sign up, so if you don't like it, there's nothing to cancel. And because Clarified is Cloud Based, there is nothing to install!

On the Clarified.biz website, entrance to the Clarified portal, you will find information about the product, dashboard samples and videos on how to use CLARIFIED for Clarizen. When logged in, you will have access to the standard dashboards, Clarified Excel file, the online manuals and frequently asked questions.
For more information on Clarified for Clarizen, please visit the Clarified.biz website or contact us via info@bi-architects.nl.

Hermann-Otto Israël
Customer Success Manager
BIA Architects

Working with graphs in Clarified is easy!

Create a project performance chart within a few clicks.

The following demo shows you the ease of use of the Clarified Excel file. In this demo we use the Clarified Excel and MS Excel pivot table functionality.



Click here to go to the Clarified for Clarizen website.

Clarified for Clarizen published in Apps Marketplace

With great enthusiasm we introduce the Analysis and Reporting extension CLARIFIED for Clarizen to you. Working closely with Clarizen, BI Architects developed this extension. We developed it for Clarizen customers who require extensive analysis of their Clarizen project data and/or in need of extensive reporting features including dashboards and KPI's. The extension is published today in the Clarizen Apps Marketplace here.

Click here to sign up for a FREE 30-Day Trial.


The Clarizen Extension

The extension enables you to analyze your Clarizen data across all projects, using various criteria from a management point of view (highlights, KPI’s) or with detailed views for specific projects (Trends, EVA, CPI, SPI, Milestones etc.). All this within just a few mouse clicks. You can think of criteria like: Customers, Employees, Time periods, Project types and Task types.

To mention some examples what this analysis might bring you:
• Analysis on task types helps you to make reliable estimates for new projects
• Analysis by employee allows you to compare the performance with colleagues
• Analysis of project types will help you better determine what types of projects are successful and
  which are less successful
• Analysis on customers gives you insight into the profitability of customers.

Click here to download our Clarified for Clarizen brochure.

Microsoft downgrades storage capacity from 25 GB to 7 GB

Microsoft has released SkyDrive applications for Windows and Mac , that integrates the cloud service into the operating system. In addition, the storage capacity for new users is decreased from 25 GB to 7GB.

Microsoft has also adapted the available storage capacity. Previously, SkyDrive users had access up to 25GB of space to store their files. Now this is reduced to 7GB for new users.

For current users who have files on their SkyDrive, 25GB may be retained, however they must separately indicate that they want to keep their 25 GB of storage. According to Microsoft uses roughly 99 percent of users less than 7GB and therefore few people will get into trouble by the reduction.

If you want to keep the 25 GB of storage instead of 7 GB go here!

BI Architects visited the Microsoft SQL Server 2012 symposium

Yesterday a delegation of BI Architects visited the Microsoft SQL Server 2012 symposium at the Media Plaza in Utrecht.

During the symposium Microsoft presented the new version of their informationplatform SQL Server 2012. Richard Chin, general manager SQL Server strategy at Microsoft, kicked off the symposium with a keynote. After the keynote the symposium was divided into three blocks: Breakthrough insight with SQL Server 2012, Delivering Mission Critical Confidence to the Modern Enterprise and Building the Modern Enterprise with Hybrid IT.

A view at the stunning Media Plaza during the Microsoft SQL Server 2012 symposium.

As BI Architects we were mostly interested in the block concerning business intelligence, Breakthrough insight with SQL Server 2012. This block included a keynote from Marcel Westra, technology specialist BI at Microsoft NL, explaining the vision behind SQL Server 2012 and demonstrating the new features like PowerView and the integration of Hadoop (Big Data).

All of the speakers outlined five points off improvement for SQL Server 2012:

• Greater availability. Deliver the required 9s and data protection with AlwaysOn, delivering added functionality over CTP3 that allows customers to experience multiple, readable secondaries for distributed scale of reporting and backup workloads and support for FileTable and FILESTREAM which brings first-class HA to complex data types.
• Blazing-fast performance. More effectively govern performance in multi-tenancy environments like private cloud. Resource Governor enhancements include support for 64 resource pools, greater CPU usage control, and resource pool affinity for partitioning of physical resources and predictable resource allocation.
• Rapid data exploration. Empower end users with new insights through rapid data exploration and visualization. Discover new insights at the speed of thought with more feature/functionality in Power View, the highly interactive, familiar browser-based data exploration, visualization, and presentation experience for end users.
• Credible, consistent data. In addition to CTP3 functionality delivered for Data Quality Services and Master Data Services, customers can better support heterogeneous data within Data Warehouses through new Change Data Capture (CDC) support for Oracle.
• Optimized productivity. Optimize IT and developer productivity across server and cloud with the new SQL Server Data Tools, a unified development experience for database and business intelligence projects, and cloud-ready capabilities within SQL Server Management Studio for snapshot backups to the Windows Azure Platform. Additionally, SQL Server 2012 offers a new version of Express – LocalDB. SQL Express LocalDB is a lightweight version of Express with all its programmability features, yet runs in user mode with a fast, zero-configuration installation and short list of pre-requisites. For more information and to try it out, go here.

There are three main editions planned for SQL Server 2012: Standard, Business Intelligence (new) and Enterprise. Business Intelligence adds better reporting via PowerView, PowerPivot for SharePoint Server, Data Quality Services, Master Data Services, and an In-Memory Tabular BI Semantic Model.

For more information about the new features go here.

All of the keynotes will be posted online by Microsoft,  keep watching this blog to find out were you can watch them!

Update:
The videos aren't online yet, but Microsoft sended the presentation to us in the PDF file format. Download the 15 MB zip file from this link.

Query to find the size of the database and database file

Technique 1:


     EXEC sp_helpdb

Technique 2: For a specific database:

sp_helpdb'adventureworks'

And you get the following output: (this one gives you the database and data file information for a specific database)




Technique 3: be in the context of the database and run sp_spaceusedGives you the database size and certain more properties of it:


     EXEC sp_spaceused

This is what you get:

Technique 4: use sys.master_files


SELECTDB_NAME(database_id)AS DatabaseName,
Name AS LogicalName,
size*8/1024 Size_in_MB,
max_size
FROM sys.master_files
WHEREDB_NAME(database_id)='AdventureWorks'
GO




If you liked this post, do like us on FaceBook at http://www.facebook.com/pages/BI-Architects/249973345047634?sk=wall

Notepad++ a free and useful tool

Notepad++ is a free source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License.

Almost every day I use Notepad++ for text file editing and from time to time to look at source files like Javascript and CSS. It supports syntax highlighting for various languages, which I find very useful. Notepad++ supports various plugins and does also have a column editing mode. To enable column editing mode just hold the "Alt" key and select the text with your left mouse button.

Notepad++ can be found here.

Some useful features of Notepad++:

• Syntax Highlighting and Syntax Folding
• Find and replace over multiple documents
• File comparison
• Zoom in and zoom out
• Multi-Language environment supported
• Drag-and-drop

SSMS - Saving changes is not permitted

When you design a table in a SQL Server database and then try to make a change to a table structure that requires the table to be recreated, SSMS (SQL Server Management Studio) will not allow you to save the changes.

The error you will get is:
“Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.”

Disable “Prevent saving changes that require the table re-creation” 
In SSMS go to Tools | Options | Designers | Tables and Designers as shown in the below snippet. Under Table Options you need to uncheck “Prevent saving changes that require the table re-creation” option and click OK to save changes. Now SSMS will work like expected.

Important
Microsoft recommends that you do not work around this problem by turning off the Prevent saving changes that require table re-creation option. For more information about the risks of turning off this option, see the "More information" section in the kb article from Microsoft on : http://support.microsoft.com/kb/956176

SSMS – Change Select Top 1000 Rows or Edit Top 200 Rows

In SQL Server Management Studio (SSMS) it is possible to select the Top 1000 or edit the Top 200 rows in a table or view. When you right on a table or view in SSMS, you will see the Context menu below.

In this Context menu you can:
1. Select Top 1000 Rows
2. Edit Top 200 Rows

The idea behind this is for performance reasons. But what if you want to display all the records, or edit row 250 for example? In SSMS it is possible to change these default settings. To modify the “Select Top 1000 Rows” or “Edit Top 200 Rows”  settings do the following:

1. In SSMS click on  Tools | Options
2. Select SQL Server Object Explorer . Now you should be able to see the Table and View Options
3. To select/edit All records from a table or view, specify a value of 0 to return all rows.

SSMS Tools Pack (free)

Recently I wanted to export a configuration table with data from Microsoft SQL Server 2008 R2, through generating "INSERT INTO" scripts. Because it was a big (and frustating) search in SQL Server Management Studio (SSMS) to get this done, I went looking for a tool that could simplify this.

After some googling, I found SSMS Tools Pack. SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2, Denali CTP3 and their respective Express versions. It is a very useful tool, and free to use.

Download
Go to http://www.ssmstoolspack.com/Download

Features
Click here to view all the features of SSMS Tool Pack.

Reporting Services 2008r2 (SSRS): New Webservice Endpoint

The report server includes a new management endpoint named ReportingService2010. This endpoint merges the functionalities of both the ReportingService2005 and ReportingService2006 endpoints, and can support management operations of the report server in both native mode and SharePoint integrated mode. It also includes new features that are introduced in SQL Server 2008 R2, such as shared datasets and cache refresh.

If the report server is configured for native mode or SharePoint integrate mode, the WSDL for the management endpoint can be accessed using one of the following URL:

http://<Server Name>/ReportServer/ReportService2010.asmx?wsdl

The ReportService2005 and ReportService2006 endpoints are deprecated in SQL Server 2008 R2. The ReportService2010 endpoint includes the functionalities of both endpoints and contains additional management features.


For more information, see Report Server Web Service Endpoints.

BI solution delivers insight on CXL P&L attributes

BI Architects develops Business Intelligence (BI) solutions for its customers ranging from commodity trading and enterprise risk to project management.

In this video blog I want to present a BI solution we have developed for one of our customers, that uses Triple Point’s Commodity XL (CXL), giving essential insight in the in the causes of the position and mark to market movements, including physical operations (P&L attributes).

The presentation depicted below describes our customer's needs, CXL and the solution itself.



For more information on our CXL BI solution for gaining insight on P&L attributes, please contact our sales manager Erik Rongen-Kleintjens via E.Rongen-Kleintjens@bi-architects.nl .

For more information on Triple Point’s Commodity XL (CXL) software, go to tpt.com .

Microsoft Visual Studio 11 Beta to Land on February 29th

Along with the release of Windows 8 Consumer Preview, Microsoft will also be unveiling Visual Studio 11's beta version next Wednesday.
Visual Studio 11 along with Team Foundation Server 11 has "hundreds" of latest features and Microsoft is addressing a very small selection before the release of the beta version. Visual Studio 11 will offer holistic solutions and also performance enhancements for various regularly performed tasks.

Unlike Visual Studio 2010, which is full of attractive colours, the new Visual Studio 11 is more "grey" to look at. For improving the scope to focus on text without any distraction the company decided to get rid of bright colours on the Integrated Development Environment (IDE), reported ARS Technica.
The new version is simpler as well as flatter as it does not have subdivisions, gradients and any other unnecessary details. This Metro designed version looks a lot like Visual Studio 2003, Office XP and Expression Blend. However, there is another version having darker theme but same simple and flat design.
Microsoft confirmed that Visual Studio 11 beta and .NET 4.5 beta will launch on 29th February.

The default toolbars in VS 2010

The default toolbars in VS 11

For more information about the GUI go to MSDN.

How to hide Recycle Bin and All Site Content in SharePoint 2010

If you want to hide Recycle Bin and All site Content in the Quick Launch menu in SharePoint 2010, you can use custom CSS for this.

For one of our customers, we've created a custom CSS named CoreOverrides.css in SharePoint 2010. In this CSS we inserted a display:none element as follows:

/* Hide All Site Content and Recycle Bin */
.s4-specialNavLinkList
{
display:none !important;
}


How to apply the custom CSS in SharePoint 2010
To apply the custom CSS:
1. Go to Site Actions | Site Settings
2. Click on Master Page (in Look and Feel)
3. Specify a custom CSS file in Alternate CSS URL as shown below
4. Click OK

SQL Server 2012 Virtual Launch Event

On March 7th, 2012 the SQL Server 2012 Virtual Launch Event take place. This online event will allow you to immerse yourself in the exciting New World of Data with SQL Server 2012.

You will have access to over 30+ sessions to learn about the new capabilities of SQL Server 2012 at your own pace, on your own schedule. This event brings together a who’s who of industry experts and executives to tell the SQL Server 2012 story. You will also “meet” with partners, experts, and peers in a virtual “Expo Hall” to discuss SQL Server 2012 one-on-one.

For the full agenda of this event or to register, click here.

No left navigation when new webpartpages are created in SharePoint 2010

Creating webpart pages or basic pages in SharePoint is done with a click of a button. But when you view the page you've created you won't get to see the left navigation menu. The cause I reckon is that the left side navigation is defined in the Master Page in the "PlaceHolderLeftNavBar" content place holder and templates for webpart pages shipped with SharePoint are overriding this content place holder and delete its content. 


The solution for this is to change the page so it will not override the menu place holder, but inherite it from the Master Page. The place holders we are interested in are: "PlaceHolderLeftNavBar" and "PlaceHolderNavSpacer". 


Start by opening the SharePoint Designer. Open the webpart page or basic page you want to add the menu to. In code view look for the following lines and delete them:

      <asp:Content ContentPlaceHolderId="PlaceHolderLeftNavBar" runat="server"></asp:Content>

and

      <asp:Content ContentPlaceHolderId="PlaceHolderNavSpacer" runat="server"></asp:Content> 

and

      <SharePoint:UIVersionedContent ID="WebPartPageHideQLStyles" UIVersion="4" runat="server">
      <ContentTemplate>
      <style type="text/css">
      body #s4-leftpanel {
      display:none;
      }
      .s4-ca {
      margin-left:0px;
      }
      </style>


Save the file. You will get a warning saying you are about to customize the page. Just go ahead.


Hope this saves time.

BI Architects uses TurtoiseSVN for version and source control

BI Architects (BIA) is the Business Intelligence specialist in Commodity Trading and uses the following tools:

• Microsoft: development and database tools for developing solutions
• Clarizen Online Project Management software: project management
• Turtoise Subversion: revision control, version control and source control software

In this blog I would like to write about source/version control and the way we handle source/version control within our company. As mentioned we use TurtoiseSVN. TortoiseSVN is an easy-to-use SCM / source control software for Microsoft Windows and Apache. It is implemented as a Windows shell extension, which makes it integrate seamlessly into the Windows explorer.

It is developed under the GPL. Which means it is completely free, including the source code. But just in case you don't know the GPL too well: you can use TortoiseSVN to develop commercial applications or just use it in your company without any restrictions.

TortoiseSVN is a Subversion client and therefore has all the features of Subversion itself, including:

• Most current CVS features.
• Directories, renames, and file meta-data are versioned.
• Commits are truly atomic.
• Branching and tagging are cheap (constant time) operations.
• Efficient handling of binary files.

BI-Architects mainly uses the following TurtoiseSVN functionality:

• New solutions are created as folders in the TurtoiseSVN database.
• Via the update functionality we update our local instance with the newest (committed) database version of the solution.
• Via the commit functionality we store the updated or improved version (including the end of day situation) in the subversion database.
• Release versions are controled by using tag functionality

With using TurtoiseSVN BIA has control on software development. More information on TurtoiseSVN can be found here.

SharePoint 2010 Advanced Developer Training

For developers, SharePoint 2010 provides a business collaboration platform to rapidly build solutions and respond to business needs. SharePoint 2010 Advanced Developer Training offers technical training as self-paced modules and hosted labs for SharePoint 2007 professionals who want to upgrade their skills to SharePoint 2010.

Module 8 for example, presents Business Intelligence capabilities in SharePoint 2010. There are improvements in this area to help build Business Intelligence dashboards, which can be used to expose relevant information for business users in a meaningful way.

SharePoint 2010 Advanced Training
01 : Developer Roadmap and Tools
02 : Core Development
03 : User Interfaces and Lists
04 : Data Access in Technologies
05 : Composite Solutions
06 : Enterprise Content Management
07 : Enterprise Search
08 : Business Intelligence
09 : Communities
10 : Development Life Cycle

Developing on SharePoint 2010

As a software developer you can use the SharePoint 2010 business collaboration platform to build enterprise-class solutions for intranet portals and the web. View these ten modules on Microsoft MSDN to get started with development for SharePoint 2010 using Visual Studio 2010.

Module 01: Getting Started: Building Web Parts in SharePoint 2010
Module 02: What Developers Need to Know About SharePoint 2010
Module 03: Building Blocks for Web Part Development in SharePoint 2010
Module 04: Accessing SharePoint 2010 Data and Objects with Server-Side APIs
Module 05: Accessing SharePoint 2010 Data and Objects with Client-Side APIs
Module 06: Accessing External Data with Business Connectivity Services in SharePoint 2010
Module 07: Developing Business Processes with SharePoint 2010 Workflows
Module 08: Creating Silverlight User Interfaces for SharePoint 2010 Solutions
Module 09: Sandboxed Solutions for Web Parts in SharePoint 2010
Module 10: Creating Dialog Boxes and Ribbon Controls for SharePoint 2010

Clarizen in top 25 most important Online PM Software

Clarizen, the online project management solution, was selected as one of the top 25 of the most important Online project Management Apps by GetApp.com. The infographic on Top Online Project Management Software can be found here.

BI Architects uses Clarizen for managing its projects and has developed a BI solution for Clarizen. More on our BI solution can be found in this blog Business Intelligence extension for Clarizen.

Setting the Protection Level of Packages

The following table describes the protection levels that Integration Services provides. The values in parentheses are values from the DTSProtectionLevel enumeration. These values appear in the Properties window that you use to configure the properties of the package when you work with packages in Business Intelligence Development Studio.

Protection level	Description
Do not save sensitive (DontSaveSensitive)	Suppresses the values of sensitive properties in the package when the package is saved. This protection level does not encrypt, but instead it prevents properties that are marked sensitive from being saved with the package and therefore makes the sensitive data unavailable to other users. If a different user opens the package, the sensitive information is replaced with blanks and the user must provide the sensitive information.
	When used with the dtutil utility (dtutil.exe), this protection level corresponds to the value of 0.
Encrypt all with password (EncryptAllWithPassword)	Uses a password to encrypt the whole package. The package is encrypted by using a password that the user supplies when the package is created or exported. To open the package in SSIS Designer or run the package by using the dtexec command prompt utility, the user must provide the package password. Without the password the user cannot access or run the package.
	When used with the dtutil utility, this protection level corresponds to the value of 3.
Encrypt all with user key (EncryptAllWithUserKey)	Uses a key that is based on the current user profile to encrypt the whole package. Only the user who created or exported the package can open the package in SSIS Designer or run the package by using the dtexec command prompt utility.
	When used with the dtutil utility, this protection level corresponds to the value of 4.
Encrypt sensitive with password (EncryptSensitiveWithPassword)	Uses a password to encrypt only the values of sensitive properties in the package. DPAPI is used for this encryption. Sensitive data is saved as a part of the package, but that data is encrypted by using a password that the current user supplies when the package is created or exported. To open the package in SSIS Designer, the user must provide the package password. If the password is not provided, the package opens without the sensitive data and the current user must provide new values for sensitive data. If the user tries to execute the package without providing the password, package execution fails.
	When used with the dtutil utility, this protection level corresponds to the value of 2.
Encrypt sensitive with user key (EncryptSensitiveWithUserKey)	Uses a key that is based on the current user profile to encrypt only the values of sensitive properties in the package. Only the same user who uses the same profile can load the package. If a different user opens the package, the sensitive information is replaced with blanks and the current user must provide new values for the sensitive data. If the user attempts to execute the package, package execution fails. DPAPI is used for this encryption.
	When used with the dtutil utility, this protection level corresponds to the value of 1.
Rely on server storage for encryption (ServerStorage)	Protects the whole package using SQL Server database roles. This option is supported only when a package is saved to the SQL Server msdb database. It is not supported when a package is saved to the file system from Business Intelligence Development Studio.

Operators (SSIS Expression)

This post describes which operators you can use within the SSIS expression language.

Operator	Description
Cast (SSIS Expression): Convert SSIS Data Types	Converts an expression from one data type to a different data type.
() (Parentheses) (SSIS Expression)	Identifies the evaluation order of expressions.
+ (Add) (SSIS Expression)	Adds two numeric expressions.
+ (Concatenate) (SSIS Expression)	Concatenates two expressions.
- (Subtract) (SSIS Expression)	Subtracts the second numeric expression from the first one.
- (Negate) (SSIS Expression)	Negates a numeric expression.
* (Multiply) (SSIS Expression)	Multiplies two numeric expressions.
/ (Divide) (SSIS Expression)	Divides the first numeric expression by the second one.
% (Modulo) (SSIS Expression)	Provides the integer remainder after dividing the first numeric expression by the second one.
|| (Logical OR) (SSIS Expression)	Performs a logical OR operation.
&& (Logical AND) (SSIS Expression)	Performs a logical AND operation.
! (Logical Not) (SSIS Expression)	Negates a Boolean operand.
| (Bitwise Inclusive OR) (SSIS Expression)	Performs a bitwise OR operation of two integer values.
^ (Bitwise Exclusive OR) (SSIS Expression)	Performs a bitwise exclusive OR operation of two integer values.
& (Bitwise AND) (SSIS Expression)	Performs a bitwise AND operation of two integer values.
~ (Bitwise Not) (SSIS Expression)	Performs a bitwise negation of an integer.
== (Equal) (SSIS Expression)	Performs a comparison to determine if two expressions are equal.
!= (Unequal) (SSIS Expression)	Performs a comparison to determine if two expressions are not equal.
> (Greater Than) (SSIS Expression)	Performs a comparison to determine if the first expression is greater than the second one.
< (Less Than) (SSIS Expression)	Performs a comparison to determine if the first expression is less than the second one.
>= (Greater Than or Equal To) (SSIS Expression)	Performs a comparison to determine if the first expression is greater than or equal to the second one.
<= (Less Than or Equal To) (SSIS Expression)	Performs a comparison to determine if the first expression is less than or equal to the second one.
? : (Conditional) (SSIS Expression)	Returns one of two expressions based on the evaluation of a Boolean expression.