.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

The general state of SSIS as an Industry Standard

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
I wanted to solicit the feedback of the SSIS forum experts, as to their take on the state of SSIS as an industry standard application for processing files.  I've been using SSIS for close to a year, and have implemented some pretty complex solutions using it.  And from the beginning, I found myself annoyed by many of its quirks and limitations, some of them surrounding seemingly basic principles.  Even more annoying, is the fact that Microsoft seems to dismiss these limitations, as if they're not important.  With the release of SQL Server 2008, their obvious lack of attention to SSIS evident by it's minuscule enhancement list makes me feel that the support is not there -- by the industry, and therefore, by Microsoft.

I care, because I've found SSIS making my life easier, overall, when it comes to processing data from and to files, and I can see its potential.  But on the other hand, I am concerned that I (and the company I work for) may be investing too much energy into a technology that does not seem to be gaining support by the industry -- and again, consequently, by Microsoft.

Is SSIS going to continue to just be a back-burner solution, just used by a niche group of individuals, or will it eventually catch on and become more of an industry standard, and ultimately require Microsoft to put more of their own invest

View Complete Post

More Related Resource Links

Move SSIS from Enterprise Ed to Standard




We have developed a SSIS solution on SQL Server 2008 R2 EE (64 bit) and now a client would like it on SQL Server 2008 R2 (64 bit), are there any issues? Workarounds ?



Indexed Views are supported by SqlServer Standard Edition - why do all feature lists state the oppos


Hi there,

years ago I had already wanted to apply indexed views for a certain query tuning problem, but read that they are only supported in SqlServer Enterprise Edition. I came back to that topic recently, and again all the official documentation I found confirms that assumption (e.g. http://msdn.microsoft.com/en-us/library/cc645993.aspx).

I gave it a try anyway, and could easily create indexed views on Standard Edition. I checked the execution plans, and the view's indizes were applied. The only small restriction I encountered was, that I had to supply a "with (noexpand)" query hint in the from clause. It even works on SqlServer 2000 Standard Edition.

This is such a valuable feature, probably seldomly applied, because articles and postings everywhere imply that Enterprise Edition is a requirement. I suppose it would be a good idea to correct Microsoft's documentation on that topic. Thank you!

Kind regards, Arno

SSIS Environment Variable Standard Edtion Vs Enterprise Edition



We current use SQL 2005 Enterprise Edition and we have our SSIS package working great where the server names are picked from Environment Variables file stored on the server. We are now planning to use SQL 2008 R2 STANDARD edition and for some reason the SSIS package which works great on SQL 2005 using variables is not working on SQL 2008 R2. It complains about not able to find the location/environment variables.

Question: Is the Environment variables thing supported in SQL 2008 R2 STANDARD Edition?


Thanks !


Truly Understanding View State

This article provides a detailed understanding of the ViewState.

Microsoft SharePoint Online Standard Developer Guide

Developers Guide for SharePoint Online (Standard Offer). Microsoft® Office SharePoint® Online is a collection of Web-based tools and technologies built on Microsoft Office SharePoint Server 2007 that help you store, share, and manage digital information within your company. This white paper describes the customization (or extensibility) capabilities that are supported with the Standard offering of SharePoint Online

Design Patterns - Using the State Pattern in C#

What is the State Pattern?

The State Pattern is a behavioral pattern that can be used to alter the behavior of an object at run time. As the state of an object changes, the functionality of the object can change drastically. This change of behavior is hidden from the Client and the Client interfaces with a wrapper object known as the Context. The State Pattern is a dynamic version of the Strategy Pattern.

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

view state vs request parameters


If  the view state is the data entered into the form fields then they are supposed to be available in the request parameters or request body. Then why would we need view state for?


SQL Server Session state problem.


Hi to all,

I have some things that I want to know. I am right now using a free asp.net webhosting ("somee.com"). The problem is that when I am visiting a page, there's a tendency that values stored in my session variables are lost. Therefore, it causes an error when the requested page is loaded.

1. I am thinking of using sessionState mode="SqlServer". Will it solve my problem?

Actualy Im working on it but Im having problems when connecting to the sql database.

2.  Is that a problem in the webhost?

3. Do free webhosting sites provide allow session state in the sql server?. Because ive tried it locally into my computer and error say's i should intall the ASP.NET Session State SQL Server version 2.0 or above.

View State Encryption


Hi All,

Why is it that I see the same hash value generated when I use different algorithms for viewstate encryption. I have added below lines to the web.config file

<pages viewstateEncryptionMode="Always"

browser gives jibberish when State manager (sql) is turned on


Hi all, we're testing our web app with a state manager so that we can do distributed rollouts. We're not getting any errors, but we are getting jibberish returned for every page request. 

(it won't even let me paste it in here)

HOw do I get it to serve the pages normally?


Custom Server Control Property not maintaining state


I have created a server control consisting of a TextArea and a div under it.  My goal is to create my own asp:TextArea type control.  the div is for a Character count of the text area and seems to work ok but i added a CharacterCountVisible property to the control that is always returning true.  See Proptery definition below


<Bindable(False), Category("Appearance"), DefaultValue("True"), Localizable(True)> Property CharacterCountVisible() As Boolean
        Return _CountBoxVisible
    End Get
    Set(ByVal value As Boolean)
        _CountBoxVisible = value
    End Set
End Property

Note the _CountBoxVisible variable is define inside the class as :

Dim _CountBoxVisible as Boolean = True

What I am trying to do is give the user/coder the option to show/utilize the char count feature.  Can make it disappear with textarea1.CharacterCountVisible = False but setting it to true will not make it display.


What am i missing





Device detection: standard & mobile web applications


I would like to host standard web pages as well as mobile web pages on a single website/virtual directory.


Is there a simple way of sniffing out the machine type and then presenting either web or mobile application depending on the device?

Or is there a better solution other than creating separate website?

Many thanks

Security Briefs: View State Security


Effectively managing user state in web applications can be a tricky balancing act of performance, scalability, maintainability and security. The security consideration is especially evident when you're managing user state stored on the client. Here's what you need to know about view state security.

Bryan Sullivan

MSDN Magazine July 2010

CLR Inside Out: Handling Corrupted State Exceptions


There's a danger in using one-size-fits-all exception handling, and you need to know how to avoid it by being as specific as possible about how you handle errors.

Andrew Pardoe

MSDN Magazine February 2009

Foundations: Managing State With Durable Services


This month Juval Lowy tackles questions such as when to keep proxies and services in memory for better state management in long-running workflows.

Juval Lowy

MSDN Magazine October 2008

WCF P2P: How To Design State Sharing in a Peer Network


Learn how you can peer-enable business applications by allowing them to share state in a serverless peer network.

Kevin Hoffman

MSDN Magazine July 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend