Jacksonville, Fla.— Pragmatic Works™, www.pragmaticworks.com, a Microsoft Managed Partner and provider of business intelligence solutions that complement Microsoft SQL Server 2008 R2 released the DTS xChange Migrator Pack™ 2.0 with an added feature called Snippets. The Snippet technology democratizes SSIS development by replacing old DTS Active X scripts with drag and drop code snippets.
The latest version of the DTS xChange Migrator Pack includes:
• DTS to SSIS migration: using DTS xChange™ technology.
• Snippet Wizard Use Snippet Wizard to replace DTS Active X components, add reusable code from snippet library. Snippet framework is extensible framework to create reusable scripting code and control flow.
• NEW: Package Builder Wizard for quickly building packages from several predefined templates. Create new packages from predefined package templates or modify existing packages
• NEW: Three new Date Time expressions for BI xPress™ Expression Edit dialog box.
• NEW: Shows correct icon instead of generic task icon for 3rd party tasks in Expression List
• Auditing Framework - easily track how long each package took to execute by date, computer, environment (QA, Prod, etc.), machine type, and more.
• Notification Framework - receive instant e-mails and/or text messages, notifying you of package errors, warnings, successes, and failures.
• Deployment Utility - easily deploy single or multiple SSIS packages at one time, along with their Configuration Files.
“All of us in the SQL Server community have been watching the clock tick away on SQL Server 2000 DTS support,” says Pragmatic Works’ President Brian Knight. “However many companies have not had the bandwidth to complete their migrations and are turning to costly consulting contracts to get their migrations done before support ends. With our DTS xChange Migrator Pack they’ll save 90% or more on the DTS migration cost even if they outsource the project. ”
Cigna saves years on their SQL Server DTS to SSIS migration project.
“Cigna wanted to upgrade to 64-bit SQL Server 2005 from 32-bit SQL 2000 to consolidate the number of servers. The challenge was migrating thousands of DTS packages on a timely basis. Without DTS xChange, Cigna estimates the upgrade would have taken years, the conversions would have been less precise and would have required significantly more testing resources.” Says Mark W, Database Administration Manager, Cigna Information Technology
The DTS xChange Migrator Pack, integrates with Microsoft Visual Studio (BIDS) allowing for a familiar development interface and minimal training, easily builds SSIS packages and views historical reports about package activity, performance trends, errors and/or warnings, extracted and loaded records summary along with source and target information, such as table and file names. For a free trial go to http://www.pragmaticworks.com
