SSIS Whitepapers from Microsoft

I was reading Jamie Thomson's “Life the Universe and SSIS” blog the other day and came across these two interested posts

Which highlight a number of interesting SSIS related whitepapers that Microsoft has released recently. 

We are only just starting to get into our first two projects using SSIS at work and even though they are going well I can tell we are still on the early part of the learning curve. The product has not been around long enough for “Best Practices” to have emerged so it is good to be getting some information “direct from the horses mouth”.

Update [17 Apr 06]: Jamie has informed me that he has been compiling his own list of SSIS best practices on his blog at: http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx - it's a great resource, well worth a read if you are working with SSIS. Thanks Jamie!

 

Print | posted on Wednesday, April 12, 2006 10:02 PM

Comments on this post

# re: SSIS Whitepapers from Microsoft

Requesting Gravatar...
Hi Darren,
You're right that best practices don't exist but I have made a stab at some myself: http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx
Notice I say these are my own opinions. I do't want people accepting my word as gospel :)

-Jamie
Left by Jamie Thomson on Apr 12, 2006 10:11 PM

# re: SSIS Whitepapers from Microsoft

Requesting Gravatar...
I am just starting to look at SSIS as a method to integrate our sql server and progress based systems replacing our ftp/flat file spaghetti interfacing. A colleague has asked why use SSIS and not BizTalk - do you know of any resources that explain the scenarios in which to use either product? They both seem to be similar in what they are trying to achieve......
Left by nasbags on May 17, 2006 4:41 PM

# re: SSIS Whitepapers from Microsoft

Requesting Gravatar...
I can't think of any off the top of my head. There is definitely some overlap where you could use either product. I often explain Biztalk to people as being like SSIS, but at a transational level. SSIS probably comes more into it's own when you are dealing with bulk information. Biztalk has a lot of strengths when you have longer running processes. SSIS is also free with SQL Server, Biztalk is a separate product.
Left by Darren Gosbell on May 17, 2006 8:31 PM

# re: SSIS Whitepapers from Microsoft

Requesting Gravatar...
We are using both products at a current client and have faced some resistance from executives who believe BizTalk to be the "strategic platform for all integration". I believe the now infamous Microsoft integration paper helped us to distinguis and separate the products in the minds of our clients.


http://www.microsoft.com/technet/prodtechnol/biztalk/2004/whitepapers/integration.mspx#EBAAC

Left by KR on Jul 21, 2006 9:57 PM

# re: SSIS Whitepapers from Microsoft

Requesting Gravatar...
There is definitely a bit of overlap between Biztalk and SSIS.

This is very simplistic, but I usually position SSIS as a tool for batch or bulk data transformations and Biztalk as a tool for integrating at a transaction or message granularity.
Left by Darren Gosbell on Jul 23, 2006 8:01 PM
comments powered by Disqus