Upgrade pacakges from SQL 2008 R2 to SQL 2014

Hello everyone,

I've around 14 dtsx files, which needs to be upgraded from SQL server 2008 R2 to SQL server 2014.

I've opened them directly in SSDT BI for VS 2013 to upgrade to SQL server 2014.

3 packages out of 14 did not get upgraded to SQL server 2014. The error log displays no. of errors for these 3.

Errors like,

     * Error 0xc02090f6: Data Flow Task: The property "ABC" on the XML Source was empty.                        

                * Error 0xc004706b: Data Flow Task: "PQR" failed validation and returned validation status "VS_ISBROKEN".       

                * Error 0xc004700c: Data Flow Task: One or more component failed validation.                   

                * Error 0xc0024107: Data Flow Task: There were errors during task validation.  

                * Error 0xc001f429: Package Upgrade: The validation of the package XYZ.dtsx has failed.

Can anybody please advise how to get rid of these errors? Any help would be much apprec

August 31st, 2015 5:29am

Hi Ankit,

Please check the below link

http://bidn.com/blogs/DevinKnight/ssis/2718/upgrading-packages-to-ssis-2012

Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 7:13am

Hi Ankit,

If I understand correctly, the value for property ABC is empty at design time, though it has correct value during runtime. The issue is that the XML Source is trying to validate a property ABC during the design time. So the error occurs.

To avoid this issue, please change the ValidateExternalMetadata property of XML Source to False or change DelayValidation property on the Data Flow Task to True.

The following similar threads are for your references:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/dc74eca6-45e5-4c48-bf0e-e7c9b937eda2/the-property-xmldatavariable-on-the-xml-source-was-empty-case-foreach-loop-container?forum=sqlintegrationservices
http://stackoverflow.com/questions/10336263/how-to-fix-source-is-empty-error-in-xml-source-while-using-foreach-loop-containe

Thanks,
Katherine Xiong

September 1st, 2015 2:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics