Question: What was that email and blog address?
Answer: email@example.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?
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?
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: