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?
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy 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
All Courses

From novice to tech pro — start learning today.