Link to home
Start Free TrialLog in
Avatar of juliakir
juliakir

asked on

SSIS upgrade from 2008 to 2016 SP1

What is the best way to upgrade 2008 SSIS packages to 2106 SP1

All script tasks disappear during regular upgrade . Please share some experience

thanks
Julia
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Could you please mention how you upgrade packages??
It will help us to identify the issues.

I tired the same process. I developed integration package in SSDT 2008 with script task. It worked fine.

Than directly add that package to new solution created in SSDT2015. It asked for permission to upgrade once i grant a permission, it was done.

And tested the execution as well, its working fine.
Avatar of juliakir
juliakir

ASKER

Hi Arifhusen,

I have package developed in BIDS 2008

I created new project/solution in VS 2015 and added  dstx file created in 2008

I get Warning:
"Found SQL Server Integration Services 2008 Script Task "ST_guidnumber" that requires migration"

After I go inside script task it is empty

thanks
Julia
If you don't mind. Can you please attache on package here. So i can make a test ?
I cant attach package . Proprietary info
Ok. I can understand.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.