People wich work with many technologies has many troubles to convert and migrate the data.
Fortunately, nowadays we have ESBs in our lives. lol
A long time ago Microsot created the DTS (Data Transformation Services) to import/export data… Since Sql Server2005 it created the Sql Server Integration Services.
Anyway… some companies still use the 2000 version and the DTS is alive in their world.
That’s our time, we need to use it and sometimes call a DTS package from another app.
In this simple example I’ll show how to call a DTS Package from T-SQL.
Feel free to put the code in a stored procedure, job… 😀
DECLARE @CMD NVARCHAR(1000)
SET @SERVERNAME = @@SERVERNAME
SET @CMD = ‘DTSRUN /S’ + @SERVERNAME + ‘ /Nyourdtsname /EMICROSOFT OLE DB PROVIDER FOR SQL SERVER’
EXEC MASTER..XP_CMDSHELL @CMD
Works pretty good.