Link to home
Start Free TrialLog in
Avatar of Zack
ZackFlag for Australia

asked on

Upgrading my SSIS package in VS 2012

Hi EE,

Where do I go to upgrade my SSIS package, can't seem to find the button? See the attached picture.

Any assistance is appreciated.

Thank you.
VS-2012-Screenshot.PNG
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Hello, Zack!

I did not quite understand your question. What do you want to upgrade? The SSIS package opened in Visual Studio/SSDT indicating that the  file format upgrade required (if any) was done silently by Visual Studio. Are you facing any other errors?
Avatar of Zack

ASKER

Hi Nakul,

Yes, I getting an error Package Load error 0xC0010014 in CPackage::LoadFromXML when try to import the package. All I have done is replace a SQL statement in Migrate Client Data section of this package. But when I try to import the package into SSIS 2008 on the I get the package load error.

I checked the query it runs fine.

Thank you.
Query-Replaced.PNG
Avatar of Zack

ASKER

Hi Nakul,

Forgot to mention the SSIS Server is a 2008 v10.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zack

ASKER

Hi Nakul,

Okay then that would be good.

Thank you.
Avatar of Zack

ASKER

My sincere apologies I forgot about this question entirely, awarding points now thank you for your assistance on this matter.