I need to migrate packages ssis 2008 to 2017
I am looking for a method to export my packages that are on the 2008 server
on the net I find this command who has a feedback experience
SELECT 'EXEC XP_CMDSHELL ''DTUTIL /SQL ' + NAME +' /COPY FILE;
D:\SQLDBAExperts\Packages\' + NAME+'.DTSX' + ' /QUIET''' FROM SYSSSISPACKAGES
I don't know a thing about SSIS migrations except that I'm very happy that I don't have to get involved with them at all.
On the command, though, that code will create code that you need to copy and run separately. I don't know if the structure of the DTUTIL command is correct but it looks reasonable.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)