Question: What was that email and blog address?

Answer: jweston@microsoft.com/ http://blogs.technet.com/jweston

Question: If a developer has exported a SQL 2000 DTS package to VB6 code, what is the best way to migrate this code to SSIS/.Net?

Private Answer: Due to security changes DTS was completely re-written into SSIS, I would start here - http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1216481,00.html

Question: Hi John, great presentation, very informative. Would this type of work be DBA related or some thing that a Developer should do?

Private Answer: Actually it could be both, one thing John and I have always discussed is that the DBA role fits somewhere in between a Developer and an IT-Pro.

Question: Why use separate transaction task for sort and aggregate rather than use "group by" and "order by" in a TSQL statement?

Private Answer: As always there are options

Question: How about compatibility with Vista Enterprise? Any concerns here?

Answer: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

Question: Is there a list of the data sources/destinations that SSIS can work with?

Answer: Not that I am aware of here is a great Resource for SSIS - http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx

Question: What's your blog address?

Answer: http://blogs.technet.com/jweston

Question: Thanks great presentation...

Private Answer: you are welcomed

Question: Great presentation, thank you!

Private Answer: thanks, you are welcomed

Last Friday 2/23 I did a webcast on SQL 2005 IS.

Here is the Q&A log: