Helpful information and examples on how to use SQL Server Integration Services.
There are a lot of SSIS blogs out there, and I don't like being redundant. I'm hoping to find more time to blog, which got me thinking about what I should be writing about.
What type of information would you most like to see posted here? Details about what we're working on? Tutorials? Katmai information? Interesting uses of SSIS?
Also, if you have an SSIS blog that I'm not linking, please post a comment or email me to let me know. I'll happily include it in my links.
PingBack from http://msdnrss.thecoderblogs.com/2008/01/21/what-content-do-you-want-to-see-here/
What I'd like to know about
1) Katmai + 1 please :)
2) When are flowlets coming
3) Plans around expanding the use of the SSIS server
4) Auditing enhancements in the future
Basically I'm just a future-plans-whore :)
As for stuff that you are ALLOWED to write about...I'm sure people would appreciate a SSIS blog that is devoted to custom development using the API. e.g. task/component development, package generation, custom log handlers, custom connection managers, custom loop enumerators etc...
I started in the ETL world with DTS and moved to SSIS, but I don't have the benefit of knowing how SSIS compares to other, more mature ETL products in the market. I would like to see an objective comparison of SSIS against DataStage, Informatica and other similar tools, comparing feature-for-feature (I already know SSIS wins in the cost area)
Jamie's suggestion on API content is great (though he's sabotaging my plans for future content on that topic on my blog :) ). Seriously, it'd be great to get more insight on that from an inside perspective.
Batch reply -
Jamie - Talking about Katmai + 1 is complicated. I typically can't announce things here until they've already been announced somewhere else (usually at a conference of some sort). More focus on extensions is definitely an area I can cover, though. There other stuff we can discuss at the MVP summit!
Kory - haha, all of the stuff I'm NOT supposed to be talking about. That's what our MVP's blogs are for!! We're actually not supposed to use our competitors products for IP reasons - MS is always careful about that sort of thing. I believe they've done some benchmarking, but we only get the high level results (SSIS is fast ;) ). I'm hoping the sqlperf blog will post some of their findings, but benchmark results are always tricky, and usually a source of controversy.
John - I'm sure there is more than enough content for everyone!
Instead of comparing performance, I was thinking more about feature support (even existing SSIS 2005- not necessarily SQL 2008)
I remember when SQL 2005 came out and included support for PIVOT and native partitioning, my Oracle friends informed me they've had those features for years. When SQL 2008 announced spatial data types, my Oracle friends again reminded me Oracle and IBM have had these types for a while. I've been very happy with SSIS, and look forward to SSIS 2008, but want to prepare myself if my Informatica friends start to snicker when I tell them about the new features in this next release...
Here's an idea for your first "SSIS prgramability blog entry".
If I'm building a task or component that uses connection managers then I need to enumerate the connection managers in the properties pane for that component/task just like some of the out-of-the-box tasks/components do. How do I do that?
Next step, how do I limit the list to a certain subset of the connection managers (e.g. only show Flat File connection managers).
Hope to see that soon :)
I'll try to work that in :)