With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature called Project Connection Managers. If you’ve developed in SSIS previously Connection Managers require no further detailing, but for those new this is how SSIS connections to data that’s used as a source or destination. This new feature is visible in the Solution Explorer of SSDT (SQL Server Data Tools). Below you will see the traditional method (Package Deployment Model...
Read More
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. Any new packages that are created in SSIS will default to using the new deployment model. The most basic way of describing this change is now instead of deploying packages we now deploy projects. Projects get deployed to the new Integration Services Catalog, which I’ll cover in a future post. Also, you get the benefit of project parameters. which allow you to pass values...
Many of you may now or in the future have the need to upgrade your SSIS packages to the new SQL Server 2012 SSIS. Luckily, upgrading from SSIS 2005 or 2008 isn’t nearly as painful as you may have experienced upgrading old DTS (SQL Server 2000) packages. If you’re considering the upgrade to 2012 here are some of the new features you have to look forward to: Usability fixes in the development environment (Resolve References, Undo, Zoom, etc…) New/Changed Tasks and Transforms (CD...
Another SQL Rally has wrapped up in Dallas, TX and it was great event. My favorite part about these larger events is being able to meet new people and see old friends that I haven’t seen for months. Unfortunately, I did not attend any of the precons this year but I did see a lot of great sessions. I made it a point to at this event to reach outside my comfort zone with the types of sessions I attended. Here’s a wrap up of my couple days in Dallas: Thursday I started my morning by att...
We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”. Which tool(s) is the best fit for the reporting needs? Remember just picking one tool and using it for all reports may not be the best decision because you are missing out on a lot of the benefits of other tools. One tool I like to use that helps me make a decision like this is a decision matrix. With a decision matrix you provide the possible options, which for us has been the followin...