Blog - comments

Hi Helmy, If you use the GUI to create the availability group, it requires you have the same path / ...

could you please share the needed class files (or the D2.jar) it seems, this class is missing

me
but when i am gonna create an AG the following error shown >> the following folder locations do not ...
Helmy Mohamed
Nice one! I like the outfit of the characters. Wish i could do the same thing too but im not that te...
utah

Can someone please forward me all the netbackup commands with detail information I want CLI.

Shekhar D
Blog Stephane Haby SQL Server 2012: new features for Integration Services (SSIS)

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

SQL Server 2012: new features for Integration Services (SSIS)

Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new "goodies" (from CTP1 to RC0), which can be powerful for DBAs and developers.

Since CTP1

  • Deployment and Administration Enhancements

You have a new deployment model and ways to administer your data integration workloads in the company. The project deployment model provides the ability to define parameters for packages and projects and to modify the parameter values at runtime. More information here.

  • Object Impact and Data Lineage Analysis

You can now view information about impact and data lineage between supported Integration Services objects that are deployed to the server and supported SQL Server SQL Server objects. More information here.

  • Usability Enhancements

SQL Server Data Tools (SSDT) has been updated to help new and experienced users develop packages more easily. A new Integration Services toolbox, designer refinements, and other usability enhancements help new users become productive quickly.

  • Reduced Memory Usage by the Merge and Merge Join Transformations

Microsoft has made the Integration Services Merge and Merge Join transformations more robust and reliable. This is achieved by reducing the risk that these components will consume excessive memory when the multiple inputs produce data at uneven rates. More information here.


Since CTP2

  • New Reports for Troubleshooting Package Operations

In this release, two standard reports are available in SQL Server Management Studio to help you troubleshoot Integration Services packages that have been deployed to the Integration Services catalog. More information here.

  • Viewing Dependencies for Objects

You can now easily view dependencies for SQL Server objects and packages stored on different servers, using the Object Dependencies dialog box in SQL Server Management Studio.

  • Comparing and Merging Packages

The structure of .dtsx package files has been modified to make it easier for you to compare packages. You can also more reliably merge packages that don’t contain conflicting changes or changes stored in binary format.

  • Easier Access to Samples and Tutorials

The Getting Started window in the SSIS Designer provides links to samples, tutorials and videos. You can customize the window by adding links to additional content. For more information, see Integration Services User Interface. More information here.

The SSIS Toolbox in SQL Server Data Tools (SSDT) provides links to samples and Help content for Control Flow and Data Flow items. You can add links for custom components. More information here.


Since CTP3

This build provides additional elements like views, stored procedures and functions to help you troubleshoot performance and data issues.

Troubleshooting Capability Views, Procedures, and Functions
Get performance statistics and other information for an execution catalog.executions (SSISDB Database)
catalog.execution_component_phases
dm_execution_performance_counters (SSISDB Database)
Add, remove, and query data taps in a package data flow catalog.add_data_tap
catalog.remove_data_tap
catalog.execution_data_taps
catalog.execution_data_statistics
Create a dump for a running package catalog.create_execution_dump
Set a parameter value in an instance of an execution catalog.set_execution_parameter_value (SSISDB Database)

 

Since RC0

  • Shared Connection Managers

This release allows you to create connection managers at the project level that can be shared by multiple packages in the project. The connection manager you create at the project level is automatically visible in the Connection Managers tab of the SSIS Designer window for all packages.

  • Parameters

Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level. Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package. More information here.

  • Undo/Redo in SSIS Designer

You can undo and redo up to 20 actions in the SSIS Designer. For a package, undo/redo is available in the Control Flow, Data Flow, Event Handlers, and Parameters tabs, and in the Variables window. More information here.


Conclusion

You can find all information about the new Integration Services here on the Microsoft TechNet. At the moment, I have not tested all new features but I will and you will see it soon.
My SQL Server 2012 series is to be continued...Cool

Rate this blog entry:
1

Stéphane Haby is Delivery Manager and Senior Consultant at dbi Services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Certified Solutions Associate MCSA) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. He is also ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.


MCSA  MCSE  mvp

Comments

  • Guest
    west palm beach web design Saturday, 11 February 2012

    This Tricks are very helpful in my work.

  • Guest
    Internet Marketing in Delhi Friday, 06 April 2012

    Useful data. Lucky me I discovered your website unintentionally, and I’m surprised why this accident didn’t happened ahead of time! I bookmarked this.

  • Guest
    Jhon Friday, 06 April 2012

    Me personally and my friends genuinely favored the post and i believe I'm about to begin publishing my own, personal weblog in the future.Stay in touch!

Leave your comment

Guest Thursday, 28 August 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter