[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Open
  • Priority: High
  • Security: Private
  • Views: 28
  • Last Modified:

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
0
juliakir
Asked:
juliakir
  • 3
  • 3
6 Comments
 
Arifhusen AnsariBusiness Intelligence 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Arifhusen AnsariBusiness Intelligence 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 AnalystCommented:
Ok. I can understand.
0

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now