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
juliakirAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
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.
0
juliakirAuthor Commented:
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
0
juliakirAuthor Commented:
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
If you don't mind. Can you please attache on package here. So i can make a test ?
0
juliakirAuthor Commented:
I cant attach package . Proprietary info
0
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Ok. I can understand.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.