DataFlow part of the package gets corrupted when copied to the test server/project...

  • Hi,

    I have copied SSIS 2008 packages to another environment and some of the packages won't open OK anymore. In this case it seems to be the ones with one simple Conditional Split transformation. When opening Data Flow sheet, I get the error: "The connectors could not be refreshed...." and nothing appears in the work space. BUT I can run the package perfectly OK!

    Please, see the attachment for more info,

    Ville

  • Hi,

    I had to drop and recreate the transformation in the source environment and then copy again the packages...not a big task but the reason for this is still unknown but who cares:)

    I also tried to change the identifier in the XML to match the name with the one in the transformation but no-go.

    V

  • FYI

    some of the packages I needed to recreate completely...luckily the ones where simple dim update else insert packages....

    Never happened before

    V

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

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