Thanks Mike. I'll follow up on your suggestions. Cheers, Mike Kear Windsor, NSW, Australia
-----Original Message----- From: Mike Chabot [mailto:[email protected]] Sent: Thursday, 8 November 2012 8:32 AM To: sql Subject: Re: MS and SQLServer 2012 Enterprise I learned SSIS 2005 when it first came out by reading the three main books and going to some Microsoft / SQL Server conferences, along with the hands-on work. Differences with the new version can be learned through the documentation, blog posts and conference videos. I don't have any specific blog posts to recommend since I read them too long ago to remember. Microsoft doesn't advertise this, but most conference presentations can be watched for free online by registering at the conference Web site. I couldn't go to TechEd this year, but I am still able to watch the recorded presentations at http://northamerica.msteched.com. Presentations at MS conferences are usually of high quality and I know there were SSIS 2012 presentations done at the 2011 and 2012 TechEds. I've learned valuable information and best-practice guidelines at these presentations that was not available anywhere else. Many presentations are given by people actively working on the SSIS team at Microsoft, such as Matt Masson. SQLPASS.org and SQLBits.com are two other sources for good online presentations. I assume the for-profit training sites like Lynda.com have great videos as well. If you are relatively new to SSIS then the best bet is to start with one of the books. I haven't read any of the 2012 books, although Brian Knight is a good author and trainer who I would recommend. Enjoy, Mike Chabot On Wed, Nov 7, 2012 at 1:25 PM, Michael Kear <[email protected]> wrote: > > Mike do you know where I can learn how to use the 2012 version of SSIS? > The trouble with most MS documentation is links don't lead to where > they purport to go, and documentation is mostly links to other pages, > which in turn are links to other pages. And if not any of those, they > are full of unexplained acronyms so I often spend my time wading > through stuff only to find it doesn't apply to what I thought it applied to. > > Is there any tutorial material for this version? I've found lots of > tutorials that are for SQL2005 and SQL2008 which more or less apply, > but since SSIS has changed significantly, I'd like to learn about the > new version. > > Cheers > Mike Kear > > > -----Original Message----- > From: Mike Chabot [mailto:[email protected]] > Sent: Thursday, 8 November 2012 4:32 AM > To: sql > Subject: Re: MS and SQLServer 2012 Enterprise > > > My SQL Server 2012 developer edition from MSDN is 4,509,648,896 bytes, > which equals 4.19 GB. Developer edition is essentially the same as the > enterprise edition. You might want to download the developer edition > instead if you are going to use this on a development server or > workstation. With either the developer, standard, or enterprise > version you can use SSIS, although SSIS changed significantly in the > 2012 version. > > -Mike Chabot > > On Tue, Nov 6, 2012 at 2:44 AM, Michael Kear <[email protected]> > wrote: > > > > > It's been since 31 August, and I'm still none the wiser. Just > > trying things > > to see if they work. I found out that despite being told by MS > > SQLServer2012 is NOT part of my Action Pack benefits (has been for > > the > last > > 15 years), that I CAN download SQLServer2012 Enterprise from MSDN. So > > it's been downloading now for 2 days at sometimes as slow as 20KB/s > > - the file size according to the MSDN web site is 4.19GB (or if you > > look at another place in the page it's 4301MB) but it's been > > downloading and the browser shows it's 81% downloaded at 5.4GB. > > > > So does anyone know if the file Is 4.19GB, 4.30GB or 5.4GB or some other > > size? I called MS Support and after 72minutes and talking to 3 > different > > departments, they came to the conclusion they didn't know. They > couldn't > > tell me if I should just wait for it to finish, or stop and restart. > > > > And even then, I still don't know if I download and install > > SQLServer2012 Enterprise I'm going to be able to use SSIS. > > Nothing's > worked yet. > > > > Cheers > > Mike Kear > > AFP Webworks > > Windsor, NSW, Australia. > > > > > > > > > G'day Maureen, Glad to see someone's still here! > > > > > > I'm having problems moving my dev machine from SQLServer2005 > > > (express > > > edition) to SQLServer2012 Business Intelligence. > > > > > <snip> > > > > > > > > How can I transfer data back and forth between my clients' > > > SQL2005 online databases and my dev SQL2012 machine? > > > > > > Cheers, > > > Michael Kear, > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3459 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
