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 appreciated.

  • Sounds like you need to open up those dataflows and make sure that everything is looking correct. Specifically, I would check the following:

    1) Connections: source and destination both reachable.

    2) Columns: for source and destination, make sure that the packages' 'expectation' of columns matches what is actually there.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply