One of the most interesting features of DTS was its Designer component, which used to run within SQL Enterprise Manager – the “old” SQL Management Studio – as an external module.
Microsoft sql server management studio 2014 download update#
Among the various things I had to do to update their software packages, the hardest issue was to make the Data Transformation Services (DTS) Designer components work with with a not-so-terrible version of SQL Server Management Studio, such as SSMS 2008 – which you can still download from this MS official link.įor those who don’t know it, the DTS Designer components is a software package which allows developers to work with the Data Transformation Services objects with a visual GUI: such tool was quite popular in early 2000’s, from SQL Server 7 to SQL Server 2000 and it basically allowed data to be transformed and loaded from heterogeneous sources using OLE DB, ODBC, or text-only files, into any supported database (MS Access, SQL Server, Microsoft Jet and so on). Today I had to update a certain number of old Windows Server 2003 and Windows XP virtual machines to their Windows Server 2016 and Windows 10 up-to-date counterparts. SQL Server 2000 DTS Designer components are required.
0 kommentar(er)
