Question: What was that email and blog address?


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 -,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?


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 -

Question: What's your blog address?


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: