1

We need to migrate approx 100 SSIS jobs currently on SQL Server 2008R2 to 2012/14/16

How can I download these SSIS packages and later use them while moving jobs on new servers?

Please suggest

Update@

I tried using dtuitil but the problem 7 out of 10 packages failes with below error

Could not load package "\njnbsscncsc " because of error 0xC001 1008. Description: Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.

  • Are the packages actually SSIS or are they DTS? There are lots of tools/methods out there (my favorite is dbatools) for extracting SSIS packages in bulk from a SQL Server. But it's not a straight path for SSIS. You have connection strings, improved security in the new model (which breaks things in the old), drivers and more that need to be assessed, migrated and updated. – Jonathan Fite Jul 6 '18 at 18:43
  • @JonathanFite, Is there a way to confirm? I extracted one using dtutil and they are getting saved as dtsx – BeginnerDBA Jul 6 '18 at 19:12
  • do you have the packages deployed on SSISDB? or they are as .dtsx files? – Eduardo Pivaral Jul 6 '18 at 19:23
  • @EduardoPivaral, they are stored under MSDB. S i guess .dtsx and nothing under SSISDB , this being 2008R2 – BeginnerDBA Jul 6 '18 at 19:24
  • Do you get that error on export or when deploying to the target server? – Tom V Jul 8 '18 at 7:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.