I promise, last post on SQL Q&A logs
Question: What was that email and blog address?
Answer: jweston@microsoft.com/ https://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 - https://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: https://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 - https://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx
Question: What's your blog address?
Answer: https://blogs.technet.com/jweston
Question: Thanks great presentation...
Private Answer: you are welcomed
Question: Great presentation, thank you!
Private Answer: thanks, you are welcomed