DTS or the Data Transformation Service is one of the most reliable tools in the old SQL Server 2000 deployments.  With the introduction of SQL Server 2005 editions, the DTS application has been removed from the SQL Server.  However a new SQL Server 2005 DTS-type application replaced the old architecture.  It is now called by Microsoft as Server Integrated Services.  

The SQL Server Integrated Services or SSIS performs the tasks of the former SQL DTS.  The new data integration and transformation tool follows the basic architectural precept of the DTS.  However some basic improvements can be noticed especially in the import data functions.  The new integration tool simplifies the operation and can be performed on the interface of the SQL management studio.  From this interface, numerous data import and transformation operations can be initiated.

For users of SQL Server 2000, the stored data and information created using the DTS tool can easily be exported to a new deployment of SQL Server.  The integrative function of SQL Server 2005 will allow the automation of import operation to grab previous data sets and integrated into the new architecture.

This interface will be useful especially for companies upgrading their database platforms.  By having the capability to migrate data from DTS to SSIS, business intelligence mined over the years will not be lost.

Developers will not encounter difficulties in migration as the interface between the DTS and SSIS all have their familiar Windows look and designs.  Wizards are also available to facilitate the automation of data and business intelligence migration.

Categories: News

Related Posts

News

ITIL PREDICTIVE ANALYTICS REPORT

  This ITIL report evaluates technologies and applications in terms of their business impact, adoption rate and maturity level to help users decide where and when to invest. The Predictive Analytics Scores below – ordered Read more…

News

Cybersecurity PREDICTIVE ANALYTICS REPORT

Read online and subscribe to Predictive Analytics Email Updates HERE You can have a say in which analytics you need in which timeframe: simply add your (anonymous) need to the list at https://theartofservice.com/predictive-analytics-topics-reports-urgency and we Read more…

News

Storage Technologies PREDICTIVE ANALYTICS REPORT

  This Storage Technologies report evaluates technologies and applications in terms of their business impact, adoption rate and maturity level to help users decide where and when to invest. This predictive analytics evaluates 36 storage-related Read more…