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
All script tasks disappear during regular upgrade . Please share some experience
thanks
Julia
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
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
ASKER
please see this
https://social.msdn.microsoft.com/Forums/en-US/e2e9c508-3293-4805-a2c3-f12152e39059/warning-xxxxx-found-sql-server-integration-services-2008-script-task?forum=sqlintegrationservices
looking for somebody to find magic how to get that to work
I am surprised how it worked for you ..
https://social.msdn.microsoft.com/Forums/en-US/e2e9c508-3293-4805-a2c3-f12152e39059/warning-xxxxx-found-sql-server-integration-services-2008-script-task?forum=sqlintegrationservices
looking for somebody to find magic how to get that to work
I am surprised how it worked for you ..
If you don't mind. Can you please attache on package here. So i can make a test ?
ASKER
I cant attach package . Proprietary info
Ok. I can understand.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers 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.
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.